I think the best Zelda moment was when Link was walking up to Zelda through the water, and Ganon was just sitting there. That to me was cool. I have to say I prefer Ganon a lot more as I character than Link in WW. He seemed so much cooler, I mean how he seemed more like a King trying to restore his kingdom than an ass trying to ruin a kingdom.
I would say the best moment is when you claim the triforce in aLttP.
If not that then definately when you beat the foursword boss with full bottles and bearly any life loss(I know its a moment in playing, not the game but I consider it a decent feet) Also the ending(s) in aLttP.
hey im hardcore aLttP, it was the first game that absorbed me. and Considering that my 4 year old self was better than my mother at it definately added some pride when I was playing it.(The SNES version if I was 4 or 5 right now I wouldn't be able to spell.)