I've had several of these moments. I remember being in awe of the opening mission in Call of Duty 2 (360 launch title). After that, it was Heavenly Sword. The facial animations and graphical quality were great. After that, Valkyria Chronicles and Uncharted 2.
There wasn't much in between, but the next would be God of War?