A few thoughts on games/levels containing water:

Zelda: Wind Waker + water - effin' awful. The sailing sections in-between islands completely ruined the game for me, and by the end of the Triforce hunt, I was literally tearing my hair out at the roots. A sure-fire classic ruined by the presence of far too much water.

Zelda: Ocarina of Time Water Temple - very inventive. I enjoyed this temple, and still enjoy it to this very day. Everyone else I've spoken to detests this particular dungeon, but it has a soft spot in my heart. Why? The puzzles were logical and challenging, and I felt a great sense of achievement when I finally solved them. I've memorized every key, chest and Skulltula location in the Water Temple, so it doesn't concern me when I re-play Ocarina of Time.

Super Mario 64 - rubbish. I hated swimming in the moat of the castle, I detested the Jolly Roger Bay, I despised the Dire Dire Docks, and I seethed with anger during my trials in Wet-Dry World. Whoever designed those particular levels needs to be shot through the face with a condensed suppository.

I could go on. Alas, I'm too tired.