i think my favorite water levels are the mega man ones, because there is no real limitation by oxygen, or by requiring swimming or anything. it doesn't hinder your movement very much because you can jump higher, and the worst part about them is that they usually throw in a bunch of spikes to avoid. i guess they just think water and spikes go hand-in-hand for some reason.
Not just Twilight Princess(Which is my fav) but also Ocarina of Time, Majora's Mask, Link to the Past, and Skyward Sword. Those are just the ones I've played, but I hear that ALL water levels are stupid.
Funny story: My older sister loved and loves Ocarina of Time, but hated the water level. So she would play through until the adult water temple in lake Hylia, then go "I HATE this temple!" and stop. a few months later, she would start playing and realize her last profile was in the water temple. She would instantly delete the profile and start over. She did this at least six times.
When I first played Twilight Princess, I got to the water temple. It was late night so I decided to save and rest.
The next day my younger brother was playing TP and I didn't mind since he made his own. When I asked him to let me play, he did. I was about to log on when I realized I couldn't because he deleted it which made me pissed >n< He did that like 4 times. The 4th time he deleted it, I just gave up on trying to finish the game.
But a few months later, I decided to try again and I managed to finish the game 8D