Tri Force Heroes is a fun game if you play it via multiplayer, and it has a lot of carefree charm.
The Adventure of Link isn't the worse Zelda has to offer.
The Lakebed Temple in Twilight Princess is a great water themed dungeon.
Great Bay Temple from Majora's Mask is perhaps the best water...