In is one of those things that there is always an exception to the rule and that even has to be included with Water Levels. They are a pain in the rear but also they are some very good levels in games. Here are some of my favorites.

Hydrocity City: Sonic the Hedgehog 3: I can't believe Screwattack had this level on in place of the Labrtyhn Zone. Me I think this level is great. It has alot of loops and you can run over water as well if you are fast enough and somewhere in Act 1 if you have Tails and a Magnetic Shield there is a bucket load of rings at the very top of the level.  A very fun level in my book.

Aquaria Towers: Spyro the Dragon 2: This in the very first world in the game and one thing I complement Insomniac for is making beautiful controls for underwater sections in games. You get to use the SuperFlame to take out robotic Sharks and also when you have beaten the level and got the Tailsman a new part of the level is virtually there to check out as well. Insomniac nailed this part of a level extremley well.

Lakebed Temple: The Legend of Zelda Twilight Princess: Love it or hate it Nintendo did a much better thing with this temple than the pain Water Temple which still is a pain even now. I just love the way how that switching the staircase can alter the area you go into and once you have the Clawshot the level becomes even more fun to explore. While Twilight Princess wasn't the best Zelda game it had the best Water themed Temple in the game well in my opinion anyway.

Cosmic Cove Galaxy:Super Mario Galaxy 2 : The best Water Themed level in the Mario franchise in my opinion. The Cosmic Cove Galaxy is extremley unique because you can hit a switch which actually freezes the level and the second Star is just as fun as the first. It is basically a sidescrolling section except at the end where Mario use the Drill Power up to make the Water appear so you can reach the star. Also I love how in Mario Galaxy the music changes once you go underwater.

Aquariam Park: Sonic Colors: When we finally get a good 3D Sonic game we get possibly the best level in terms of Water from the Sonic series. With beautiful music,the ability to run on water and hear the old retro Bubble Sound when underwater makes it memorable but what makes it even funner is using the Drill Power Up underwater you no longer have to worry about how much time you have to survive underwater. Plus by constantly jumping you can get out of the water. The only part I hate is that robot is a pain with those lasers at the end of one of the levels but even that doesn't stop me loving this level.

So these are some water levels I like any in particular you like from games you have liked.