Some breathless moments I can think at the top of my head.
1. Super Mario 64 - Playing it for the first time
2. Mario Galaxy- the moment mario lands on Egg Galaxy and the music starts
3. Smash Bros Melee- Seeing it in action for the first time
4. Chrono Trogger - The title screen, as well as the opening video
5. Fatal Frame 4- Entering any of the patients' room
Honorable - Skyward Sword- Taking flight into the sky accompanied by excellent music
...And that's what I got so far.
Edit: haha, oops, top 5... Hmm...
Dance my pretties!
The Official Art Thread - The Official Manga Thread - The Official Starbound Thread