Persona 4 for the PS2:When I felt sad about going back home in the end.
For Suikoden II, when the intro kicks off with a false flag op and you get the sweet sepia tone flashback cinematic, w/ the somber Reminiscence piano tune, at its conclusion.
I knew I was going to be in for one hell of a ride if they kicked it off with that theme.
Edit: Here's a copy of the video with 'OK' audio. The only videos I can find this morning are of this part in colour, which you wouldn't stumble upon naturally.
I started playing MGS3 last night for the first time. I'm only a few hours in, but if that Bond film title sequence is anything to go by it's shaping up to be one of my all time favourites.
Escaping Midgar in Final Fantasy VII.
The feeling of the unknown and excitement of what's yet to come.
Earthbound: When you find that guy selling a beach house with a "ocean view". It costs a ridiculous amount, so being a kid, of course I went and grinded fighting lower enemies getting little little money each time. I bought that "beach house" for a ridiculous sum of money, only to find out walking inside it is missing a wall, is run down, and had nothing to offer aside from being a "haha fooled you, lesson learned" thing. Great stuff.
One I can remember vividly is playing Shadow of the Colossus, I believe it's the 5th Colossi, the one that is basically a bird that flies around over the ruins in the water. That moment when he comes swooping toward you and you grab onto his wing and get taken up into the air with him, that was mind-blowing for me. I'll never forget that moment, one of the most impressive and Awe-inducing moments for me in a game ever.
Loool i remember that feel.It was 2002 and I had just climbed on the chain gun in a warthog and my friend was driving.