OOT's Water Temple was just mind numbingly annoying, but not as bad as the Great Bay Temple. I absolutely despised that dungeon so much.  Plus it had the most rage inducing mini-boss ever.