Okay, so I cleared the Water Temple tonight and...I don't want to talk about it. I wanted to throw my controller across the room, but now that it's over, I just don't want to talk or think or dream about it ever, ever again.
I think a lot of the "Ocarina of Time v. Twilight Princess" discussion online is colored by nostalgia. Having played Twilight Princess first, I prefer it over Ocarina of Time. The controls are sharper, the characters are more endearing (especially Midna), and the game is just more fun to play. I didn't play Ocarina of Time when it came out in 1998 or the 10 intervening years between its release and when I downloaded it from the Wii Shop. (I downloaded it last year, but got sidetracked when I started playing Okami, which I also enjoyed more than OoT and, yes, even more than Twilight Princess.)
I won't deny that Ocarina of Time is a masterpiece. I just think that Nintendo took note of what players had to say about OoT and tried to incorporate those changes into TP. (One example that comes to mind is being able to switch between the Iron Boots and regular boots in TP with a single button press whereas in OoT the player would have to access the menu, highlight the Iron Boots, and unpause.)
I'm going to try not to let my negative experience playing the Water Temple taint my view of the rest of the game. I did have a great time playing through the Fire Temple (probably because I didn't have to consult a game guide even once, huzzah!), so that's a positive.