Disco Elysium was full of such moments for me. Here's one:

You spend a lot of time in the game basically talking to yourself and your inner voices, and one of these voices is volition. If you put enough points into it, it'll chime in when you're having an identity crisis or struggling to keep yourself together and it'll try to cheer you up and keep you going. At the end of Day 1 in the game you, an amnesiac cop, stand on a balcony in an impoverished district reflecting on the day's events and trying to make sense of the reality you've woken up into with barely any of your memories intact. If you pass a volition check, it'll say the following line:

"No. This is somewhere to be. This is all you have, but it's still something. Streets and sodium lights. The sky, the world. You're still alive."

This line in combination with the somewhat retro Euro setting, the faint lighting, and the sombre-yet-somewhat-upbeat music was very powerful. The image it painted was quite relatable for me. I just sat there for a minute staring at the scene and soaking it all in. Even though this is a predominantly text-based game with barely any cinematics/animations, I felt a level of immersion I had rarely, if ever, experienced before.

Oh, look at that. Someone actually made a volition compilation. 😀 This video will give you a better idea of what I'm describing: https://www.youtube.com/watch?v=ENSAbyGlij0 Minor spoilers alert!