[SPOILERS, kind of!!]
While I do prefer both OoT and MM to WW, I have to say, the first time I entered Hyrule Temple in Wind Waker, where everything was black and white and frozen, and then walked out of the Temple in the back, I was blown away. That, along with the ending to Ico, is one of the most memorable videogame sequences I think I will ever experience.