I think the game that stuck out to me the most, as an adult especially when it's much harder for me to be moved by a freakin video game is Hypnospace Outlaw, which is pretty indie, and I think everyone should just look at. It captures a corner of the internet from an era gone past, and at the same time is a wonderful commentary about a tiny little community. Just so good. I love the entirety of Hynospace Outlaw.
Another that sticks out is pretty basic, but Undertale was pretty groundbreaking right when it came out--I'm really glad I played it before it became a meme--because the futility of trying to save everyone just...it wasn't possible. That got to me. That and the music really helped build up to the climax so well that it made that ending work, because any other score wouldn't have hit the same way. It needed the music to tell the story.
And one I saw recently but can't play because I get hella sick when I play first person games is Outer Wilds--I don't want to spoil the ending so much, since it's relatively recent but this might be the best ending of a video game I've ever seen. It's hard to explain in a few words, since it uses a lot of space science and time shenanigans. But, the very end of the game doesn't really spell out what's going on, instead you have to interpret it yourself.
How it plays out wasn't the ending I expected, and what ends up happening I really think will stick with me for a long time because it is about
Huge spoiler for Outer Wilds
finding out that you are the answer to what you have been trying to solve the entire time. You were the thing the Nomai were trying to find. They talk about hearing a call from within the Eye of the Universe, but you are the only one who's been there, and the song you play is the only song they could have heard. (and if you fire your scout at this part, your scout shows up after the credits as still existing billions of years in the future--meaning that your scout could also be the signal they heard as well. Either way, you're the only one who's been there)
The whole game is brilliant at storytelling, but in a way that only a video game can tell a story. When the music of all your friend's comes together as one song, although we have heard it as only solos the entire game, you realize it's just a memory of everyone you know who is dead. But then that song becomes the sound you need to restart the universe--the sound of the literal Big Bang (or at least that was how I interpreted it) that freakin got me good. Man, the ending of Outer Wilds! It's lovely, it's gut wrenching, and it does so without using so many words--it's just a great game everyone should go look at it.