It's been a long time since I faced such moments perhaps due to games taking longer to make and becoming a more mature medium. Also games as a whole are more consistent at just being good instead of being built around moments. But here's my list

1. Raphael's Boss music in Baldurs Gate 3
2. GoW 2018, Kratos uncovering the floorboards and recovering those things
3. Dropping the monkey paw at the end of Obra Dinn
4. The plane moment in Indiana Jones

Honourable mentions

1. The open world reveal in ff7 rebirth didn't hit as hard as we knew it would come, but still brought a smile to my face. The other big twist at the end of the game was more confusing than epic
2. Unchartered 4 surprisingly still fits in the list from 2016. The boat chase and truck trying to kill you was awesome