I happened to love the death out of Great Bay, and I don't rven remember if this is on my old list on here, but I loved it. Gyorg did suck, tho
Gyorg's easy enough if you actually bother to learn the Zora Link swim controls and fight aggressively using the electroshield. And if you're willing to be a bit slower, standing on the central platform sniping at him with the bow turns the fight into almost as big of a joke as standing in the corner to fight Morpha.
My least favorites are:
* Jabu Jabu's Belly (Oracle of Ages) - Change the water level too early at one point? Hope you didn't save, else you can kiss completing the dungeon goodbye! Have fun starting the whole game over!
* Eagle's Tower - have to save and quit and forgot to throw the wrecking ball down a pit? Oops, you're stuck thanks to a bug!
* The Wind Fish's Egg - The library can glitch and not let you read the route. A lesser example since this glitch doesn't seem to be common, but still.
I don't know about the rest of you, but I find my progress being invalidated by glitches and oversights to be the absolute most obnoxious thing a dungeon can do.
Dishonorable mention (since it's not really a dungeon): The Sealed Grounds. Freaking Imprisoned... Especially since SS introducing Stamina makes it extra-cheap, and that seems to have been the main reason [i[for[/i] the stamina mechanic: Making the Imprisoned an extra-cheap PITA.
Dishonorable mention #2: Any dungeon where you're having to contend with the external obstacle of parents trying to limit your screentime.
Going to have to give some more thoughts to my favorites..
Regarding the Ocarina of Time Water Temple... I always see people whinging about the Iron Boots, the keys, and the water level manipulation, none of which I've ever really been bothered by. But I never seem to see people talking about the one part that does
grate on me: The ramp leading up to the boss door.