Wind Waker is one of the best looking Zelda games ever in my opinion. The dungeons were not quite as fun, but it was still a neat sea-faring adventure.
Twilight Princess isn't one of my favorites, as the muddy brown visuals make it hard to see sometimes. But you're right, the dungeons were very well designed. I also liked Princess Zelda in that game, she was awesome.
My favorite Zelda game is Link's Awakening. Have you ever played that one?


