Great thread!
Too many to remember, but here goes.
Wind Waker - Ancient Hero into, it gave me a chill in my spine and started building up that epic feeling within me of excitement. ...and DRAGON ROOST ISLAND! That place is wonderful.
Skies of Arcadia - The whole thing. The part where Vyse is deserted on his own on Crescent Isle...dreamy. It was just EPIC EPIC EPIC.
Paper Mario: The Thousand Year Door - The time in glitz pit when you keep getting the secret emails from 'x', it was all so mysterious and I was so keen to find out. Also the detective scene on the train, that is truly original and one of my favourite game parts ever. The art style of Boggly Woods is so class it made me feel all dreamy too.
Baten Kaitos - When you meet Mizuti and go to...Mira(I think thats what it was called) on the ship and theres all the strange colours and that odd music.
Tales of Symphonia - I remember it was November/Decemberish time at school and really dark and dull and every day I'd look forward to coming home in the evening and snuggling up to play Tales of Symphonia. I connected with Symphonia, I really did.
QFT. This was truly magic.