One of my most memorable moments is after saving all the Sages you go back to the Temple of Time where you meet Sheik.
But its Princess Zelda disguised as Sheik.
When Zelda says she has things she wants to tell only to you.
She then says The triforce is hidden within those chose by destiny.
She also says before she transforms unto Zelda that the seventh sage who is destined to be the leader of them all is i Zelda.
This one scene in the Temple of time until Ganon kidnaps her is so emotional for me sends goosebumps all over me everytime i see it.
Its a scene that makes me sad but also very happy.
Its more than just a scene from a game for me its just pure magic the game is fantastic but this bit just made it even better.
Nintendo really outdid themselves with that one scene.
Here is thae scene i mean.
http://youtu.be/eGhuWW2vf9Q