The intro to Prey
When you, the player, finally determine to smash your wrench into the looking glass. At this point in the game, you didn't even know you were in space. Possibly the best start to a game ever.
This. Its the only thing I can think of that just was a "omg" moment.