Hope you don't mind if I copy and paste my answer from a previous thread lol but my opinions haven't changed much over the past month
1. The Sending (FFX): 
The tone, the music, and the amazing visuals (for 2001) in this FMV sequence were absolutely bang on. The game had plenty of amazing moments, but this one invoked a very peaceful, yet sad, feeling within me, and its the scene I reference the most when FFX is mentioned.
2. The Ranch Scene (The Last of Us): 
Another game with many great scenes, including many that are more iconic, but the voice acting and music in the ranch house scene made me tear up like none other.
3. Fighting Gaius (Shadow of the Colossus): 
You could single out any of the boss fights within SOTC for being epic yet heartbreaking. The amazing score pumps you up, and then tears you down once you have completed slaying the majestic beast. My favorite fight was definitely against the earth knight. I remember running around in circles for 10 minutes having no idea what to do, when miraculously, he struck the right place and the path was finally clear. Bravo, Team Ico.
4. Riding into Mexico (Red Dead Redemption): 
I never felt more empathetic towards John Marston than that first ride into Mexico. The scenery is barren yet beautiful, So Far Away by Jose Gonzalez begins to play, and you begin to feel the weight of Marston's journey. Beautiful touch.
5. Say what, Otacon? (Metal Gear Solid 4): 
Snake is romping around his old stomping grounds, shadow moses. Just like old times! You get a trophy when you switch to birds eye view, and Otacon wants you to change to disc 2. Wait, Otacon, they only gave me one.... oh, well played Kojima.
Honorable mentions:
Welcome to Rapture/Colombia (Bioshock/Bioshock Infinite): At the beginning of each game, first encountering each of these amazing cities left a lasting impression on my brain. Ken Levine is a creative genius.
The Train Level (Uncharted 2): This is when UC2 truly made me say wow. Hanging off of a train, getting shot at by a chopper, and trying to reach Chloe. Amazeballs.
This place is huge! (Skyrim): Nothing truly has made me feel small and insignificant in a game (sorry guys, didn't play FF7 back in the old days) quite like Skyrim. When I first stepped out of Helgen and saw the immense scale of Skyrim's world, I realized I was not leaving my room for a long time.
- Also had many memorable moments playing couch co-op Twisted Metal, Tony Hawk Pro Skater, MarioKart and Smash Brothers with my family. COD4 multiplayer also brought me a lot of joy. Finally, seeing a PS1 (and later a Wii) under the Christmas tree was pure elation lol
#1 Amb-ass-ador
