I just finished the Modern Warfare 2 campaign and it was amazing!!!
Was anybody else just completely breathless at the part where you first see Washington D.C. being destroyed? I mean all those historic buildings were just completely demolished and it seemed so real but so imaginative at the same time. That scene is probably the most memorable scene of all time.
Some other notable scenes from my gaming experience:
Legend of Zelda Twilight Princess- Scene where Link stabs Ganondorf in the stomach, I really wasn't expecting that and it was epic
Mario Galaxy- The first level when you walk off the side of the planet and don't fall, it gives you vertigo and its just really cool
Final Fantasy 4- Beating Zeromus, Probably not breathtaking for most people but it was the first FF game I beat and it was such a releif after about 50 tries! 
Made this thread so that you guys can talk about parts/scenes/levels of videogames that just completely blew you away. POST AWAY!!!!


















