I'll finally make my quick Worst list. Hard to call very many dungeons bad though. Most of these are hard without being fun enough to offset the difficulty level.
Worst
Turtle Rock (ALTTP) - Whoa baby. Only on this list because of how unforgiving it is, though it is still more fun than most of...
Not sure about my order of these, but some thoughts from games I've played. I find myself favoring atmosphere and gameplay the most, complemented by music. I may do a least favorite list tomorrow.
Best
Palace of Darkness (ALTTP) - First dungeon to greet you into the Dark World, that great...