I just finished the Tower of the Gods in Wind Waker a couple of days ago. It was pretty awesome. I haven't gotten to it yet but I recall the dungeon where Link and Makar team up was pretty impressive. I'll hold my comments until I finish this replay.
I think Twilight Princess is Zelda's finest hour, but none of the dungeons are jumping out at me. I need to replay this one too!








