I remember some of my wow moments, sure.
Crysis 1, during the tank battles. Watching the mountain come sliding down had my jaw drop.
Bioshock, I was totally impressed by the terror the splicers could engender in me. The mood was perfect.
Half Life 2, though feeling staged now, had some great moments, like RavenHolm, Some of the river chase moments, etc.
S.T.A.L.K.E.R Shadow of Chernobyl while for pure visual impact more subtle than other games, allowed me to have some moments that felt really, I dunno, personally tailored to each play through.
My last wow moment was probably The Forest, but it wasn't so much a spectacle, as it was a realization paired with a hideous encounter.