Yeah, getting to the end of Xenoblade Chronicles after over 100 hours with the characters felt like saying goodbye to old friends for the last time.

The ending song made this bittersweet feeling even more powerful:

Yakuza , lost judgment , shenmue, mgs3, shadow of colossus, journey, re1, silent hill 2, tlou, dragon quest 11

I used to think the post RPG depression feeling meant "I'm never going to play this for second time".
Though there's a very short list of RPGs I've played twice (as there are always more new games), I've since learned that after a decade or two you may be willing to return to any game you cared enough to finish in the first place.

One special driving game experience for me has been this track/music in Sega GT. I've few times along years just put it on to drive around without even trying to make record time, just picking some easy comfortable car to watch and relax.

Sony's exclusive story based games are top tier for emotional stuff.
Then there's the modernized FF7 games, it's not even about the nostalgia but somehow those games just get me in a special way.
Cyberpunk 2077 had some cool and even strange emotional moments.
There's also the occasional indie title every now and then that seems to hit the spot.
Ah, there are so many that I'm forgetting as well.
It's also very much tied to the presentation for me, can't really feel much for little pixel characters with text boxes.

-

Both Ori games hit me on an emotional level that most games generally do not.  They should be on just about everyone's to play list, if they have yet to do so.  They are masterpieces.