Biggest 'holy shit' moment in a game.

[EaglesEye379]

Gears 2 - playing the Reaver and Brumak-riding levels. And the first time I saw Gears 1 graphics.

BioShock - when you find out who you are.

Another one was when I realised the sun was rising when I started playing WoW the night before.