Bioshock intro
FFVIII Intro and final boss
FFX plot twists
World of Warcraft Classic and BC login screen music.
Halo 2 Bosses
Uncharted 2 train and Uncharted 3 boat
Kingdom Hearts 1st 2 hours

1. Silent Hill 2 ending.
2. Silent Hill: Shattered Memories ending.
3. Satorl Marsh at night in Xenoblade.
4. Wonderful101. Whole game.
5. Reserved place for XenoX.

I dont have a specific order but I could name this 5:

Shadow of the Colossus-. When you first fight Avion.

MGS3 Snake Eater: When you climb the long ladder inside the mountain, after you've killed The End, and you start hearing the song for snake eater being singed all the way to the top.

Soul Reaver 2.- When you have to fight yourself and the dialogue about this, and then Kain pulls the sword out of you and he starts to get new memories all of a sudden.

Far Cry 3.- First i have to tell you guys, I have a gaming PC with three 32" sony tvs, so i played Far Cry in 5760 x 1080p. Ok back to the game, when you have to jump to a water pool from very high in order to enter a new zone, i dont remember the mission, but everytime I do this I need to hold the breath because I get it taken away for this feeling of falling.

Silent Hill.- The ending, (except the alien one), when it starts playing "tears of pain".

Honorable mentions:

The order 1886 graphics.

Silent hill 2, when you learned the truth about your wife death.

Medal of honor Frontline: the first cutscene.

FarCry 4: when you use for the first time your flying suit to climb down the mountains.

Final Fantasy 7 - numerous times throughout the game, for music and cut-scenes mostly
Resident Evil 1 - numerous times throughout the game (especially re-entering the mansion when the hunter FMV scene starts)
Halo 1 - Intro music starts
Xenogears - numerous times but riding the tower of Babel, for example

Can't think of other games doing it right now.

1. Playing my soundtrack (House Blend 2) in Burnout 3: Takedown on Xbox.

2. My first Xbox Live Rainbow Six 3 game.

3. Super Mario Sunshine (that game still holds up)

4. My first time entering a Titan in Titanfall.

5. Halo 2 launch night. Best gaming day ever!

5. The last part of Journey; Music had me in awe

4. Crossing the giant battlefield in Brothers: A Tale of Two Sons

3. Pokémon Red, beating the Elite 4 and Champion; English is not my first language so I didn't know what revives did, if a team member fainted I coudn't use it at all while battling the Elite 4 nor the Champion (almost like a mini-Nuzlocke).

2. Sly 2; Fighting the final boss. (also any part of the soundtrack)

1. There's atleast two moments in every Halo game for me; the level Halo in Combat Evolved and the Maw, the cutscene where chief blows up a cruiser in Halo 2  together with the tank ride over the bridge, any scarab moment and the warthog run in 3, Mombasa streets (music and atmosphere) and blowing the bridge, space battle and the Lone Wolf level in Reach, when you step in to the Mantis the first time and when the 117 track plays while you make a Death Star trench run in 4. I can't pick, there are so many moments in this franchise.

Red Dead Redemption - John Marston riding his horse in setting sun while the song "Compass" is playing.

Only played Far cry 3/4 on Ps3/4 but the visuals were amazing. On PC with completed maxed out I'd love to see how it looks.

Oh, also "Would you kindly."

Don't even have to say which game.

Also Earthbound, the Lumine Hall scene. That's the moment when I "got" it.

grand theft auto 3,because it was the first open world game that I remember playing. game just blew me away at the time. vice city and san andreas also gave me that feeling. fallout 3 and skyrim also had me at hello. lol