Disco Elysium honestly belongs here. Despite the obvious communist sympathies of the author, its a good game with real introspection that brought back the more vertical play style.
Disco Elysium hits me in in a way that
Planescape: Torment did since both deal so heavily with philosophy, especially moral philosophy. Kind of like what made
Fallout: New Vegas so popular in many regards. But Disco Elysium had a really strong emotional component to it. The other two games I mentioned did as well, but I felt a far deeper emotional impact from Disco Elysium I feel.
Planescape: Torment was good and some of the plot twists and how the overall storyline was handled, I actually think the way the story developed was one of the most exceptional ones in storytelling as earned plot twists go with how well developed it was. The scale of the revelations in
Planescape: Torment left me going... 'Whoa... Wow... What a well constructed mystery and story." I don't know if anything in gaming matched it.
But
Disco Elysium, that final dream sequence, and the deep personal revelations that arose from what likely made our protagonist so mentally broken... that was a real punch to the gut. The one moment in gaming that seemingly relates to that scale IMHO... was the ending of
Soma. That had a beautifully crafted rough ending as well.
I feel like... when I'm thinking of profound moments... there are several categories I think of.
There's the plot twists/relevations like you'd see in a thriller type of movie or novel. That's what we have with
Planescape: Torment and
Arcanum for example or
Knights of the Old Republic, but you also see it in
Soma and
Disco Elysium etc.
Then there's the emotionally impactful stuff that just leaves you feeling... some sort of strong emotions. And it doesn't necessarily have to make you feel bad. But something that stays with you a bit. And that's what something like the
Silent Hill 2 ending or
Disco Elysium and
Soma, which upon reflection, all can have positive endings as well. Or something like the death of Aerith in
Final Fantasy VII or the
final words of Malak for example really hit me at the end of Knights of the Old Republic.
Then there's just the games that make you think about things.
Fallout: New Vegas kinda does that (Ironically it's the DLC's that have some really strong profound moments, but none of them are really as philosophical as the main game except for
Lonesome Road... which had mixed reception). But like Kreia's ramblings in the
Knights of the Old Republic II is another good example. I'm not really into
Metal Gear and I actually didn't find it too profound myself, but this sort of moral philosophy bantering is something that the YouTuber Max Derrat, whose video I posted in the OP, seemed to find far more profound then I did.