SPOILERS FOR TWILIGHT PRINCESS!
9. Forest Temple - The monkey collect-a-thon is not interesting and the lack of connections to the Kokiri irks me to no end. I'm glad they added monkeys into the 3D games, but there isn't much substance here. It is a servicable first dungeon, but compared to the rest in the game, it doesn't stand out.
8. Hyrule Castle - The obligatory "Zelda game ends in castle or tower" really reached its limit with Hyrule Castle in TP for me. I like the NPC interaction, I like the Bulblin battle (one of the best characters in Zelda history) and those are what bump it up above the Forest Temple, but the overall dungeon isn't super interesting.
7. Goron Mines - Obligatory "the boots are too slow." No but the Goron Mines are one of the few dungeons that feel truly lived in: it feels like a functional mine system and the palpable connections to the Goron civilization gives it great atmosphere, especially with the boss being the chief (good stuff Nintendo). However, the metal boots aren't fun and they are the main gimmick, so the overall dungeon is not super great. But this is the first dungeon that really has its own identity.
6. Palace of Twilight - This is surprisingly high. I think the Twilight Realm is the second coolest place in all of Zelda (after Eventide) and since this is really the only thing there, I tend to rank it higher. However, the dungeon is pretty lackluster; then again, most Zelda dungeons I would consider lack-luster and at least this one is very memorable, especially with the Zant reveals at the end. The atmosphere is stronger than the Goron Mines, and the Sol mechanic is better than the boots so it's ranked higher than it.
5. Lakebed Temple - I'm a sucker for really hard water dungeons in Zelda: the notoriously hardest 2D dungeon Jabu-Jabu's Belly and the notoriously hardest 3D dungeon the Water Temple are two of my favorite dungeons in the series. Lakebed Temple is a tamer version of those with the central staircase, and thus, while better than the previous dungeons for the sheer interest that the central mechanic's complexity brings, doesn't identify it as in the same league as the Water Temple or Jabu-Jabu's Belly (or even the Great Bay Temple).
4. Temple of Time - Good dungeon. The atmosphere is what sells this one: going through that door after the section with the Master Sword and being in the frikin Temple of Time...WOW! I also don't mind the "control other things" dungeons as long as they are decently executed, and I think this one is. The lore connections to the Tower of the Gods justify the only-OK mechanic of controlling the statues, IMO. That opening reveal, though, really hooked me on this dungeon, and gave it a great bias in my mind, which outweighs my bias for big-wet-puzzle-box in Lakebed. Also I like big scary spiders, they are so big and so scary.
3. Arbiter's Grounds - GOOD DUNGEON! The atmosphere and backstory to this place, much like the Temple of Time, bump it up greatly, but I also prefer the execution chamber aesthetic to the pristine temple aesthetic. And the spinner is an entirely original only-OK mechanic that becomes a goddamn GENIUS mechanic during the final fight. That final fight in and of itself makes Arbiter's Grounds top 5, but the "this is where Ganondorf was killed" and "look at all the dead people" vibes are *chef's kiss* and bump it to third.
2. City in the Sky - GOOD GOOD DUNGEON! Why so much hate? Cuz it's slow and boring for much of it? Fair. I just like spending time in the City in the Sky. I like the shop, I like the Oocoo, I like clinging for dear life to the side of a slow-moving propeller like Spider-Man. I like a big scary pterodactyl trying to kill me and screaming, raising the stakes and sending shivers down my spine. I like the music, which is apparently an unpopular opinion (maybe the weird alien moaning is what turns people off to it, but I like the mystery). This is a SET-PIECE. The previous dungeons were set-pieces, lowercase, filled with semi-interesting puzzles and pretty decent atmosphere. But the being-in-the-sky of it all makes City in the Sky beat those out any day of the week. I also do like the language elements in TP and don't really mind that what I'm doing isn't that interesting as long as I get to do it in the City in the Sky.
1. Snowpeak Ruins - Best dungeon. This fetch quest actually makes sense. The ice puzzles are actually fun for the first time (looking at you ALttP), the boss fight is SO good and has biased me towards this dungeon ever since the reveal first happened. The this-is-a-mansion/military-base vibes that are reminiscent of the Forest Temple are in full force and I cannot get ENOUGH. The snowy peak aesthetic is atmospheric and the chateau-on-a-hill-filled-with-Yetis aesthetic is super cute. This dungeon is one of the best in Zelda and definitely the best in TP.