I never like sewage levels where there's murky water.
Actually I don't like videogame water in general. Probably a leftover from me playing Star Wars Dark Forces back when I was just a little boy. Because the game's old, the water texture wasn't transparent, so it just looked like a solid brown mess and everytime you would enter it you'd be attacked by these creatures you couldn't see (dianogas, like the one that grabs Luke in the trash compactor in the first movie). I shat bricks when I was a kid.
And about Ocarina of Time, I myself was a few years older by then so wasn't really scary to me, but my younger cousin was also very scared of the Well, Shadow Temple and especially the Skulltula house. The guy that rated that game 'E' (and our equivalent) did not play that game.