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?

"We'll toss the dice however they fall,
And snuggle the girls be they short or tall,
Then follow young Mat whenever he calls,
To dance with Jak o' the Shadows."

Check out MyAnimeList and my Game Collection. Owner of the 5 millionth post.