Generally-speaking, with only a few select exceptions here and there, I'd say that I really dislike " water levels ". From Mario Brothers (any of them, even in SM64) to 'water-themed' levels such as the Water Temple in Ocarina of Time (which I hated at the time and still hate to this day), and so on. There are exceptions, of course. And here I'm not saying that I hate water in games per se, but there seems to be a propensity towards mediocrity whenever water is present in any particular level or fashion in a level.
I have no issues whatsoever with the water and its 'role' in a game like Bioshock, for example, and in fact it positively adds to the superb atmosphere of the game. But whenever developers try to include "water mechanics" or water-based 'puzzle solving', it generally tends to simply suck really hard. And for that reason, over the years, I've developed this automated reaction of repulsion to such levels when I see them (especially when I don't expect them at all, and boom, here's a "water level", enjoy).