The bridge scene in ICO. It left me completely stunned. I just sat there, staring at the screen. I'd never experienced anything like that before in a video-game.
Back in vanilla WoW, when I first reached Ragnaros. He was so massive and powerful. It was overwhelming. Nothing afterwards touched the feeling.