I have a lot of these moments but I'll pick my top ones.
Crystalis on the NES. When the town of Shyron gets destroyed and characters you know and care about are killed. Left me in shock as a 10 year old kid. And the temple music when you enter the pyramid is hauntingly beautiful too. I hum that tune to my kids as a lullaby.
Mass Effect 1. Exploring the planets left me in awe. For the time, the atmosphere and lore was detailed, rich, and very well thought out. Then facing down a reaper in the third game, it all made me feel so small.
FF7. Aerith getting killed took me by complete surprise. My brother and I were stunned for a while. Just sat there pondering wether it was real or not.
Minecraft back in beta. The world was just so impossibly huge and you're all alone with your creations. Left me feeling very small. The more I built, the emptier it felt.
Finally, Mad Max on the PS4. The first time I got hit by a storm I was in awe. The world is just so well built and detailed. The whole game/movie universe is filled with amazing culture that's just done really, really well.
My son just turned 5 and calls me "bruh" when he's playing Minecraft. Otherwise it's papa the rest of the day.