My favorite games are Omori, Disco Elysium and Outer Wilds. I cried for hours at the end of those games, and I think the common point in them is high-quality emotional writing and stellar OST (music really affect me) and my attachment to the characters.
I also found that my taste in movies was similar (Hana-bi by Takeshi Kitano is my favorite movie)
I've been trying to find something similar, so has anybody any recommendation?
I'd like to add that I basically hated Nier Automata (way too pretentious imo) and Before your Eyes (I wasn't a fan of the game concept, and found the story pretty weak), and really loved the horror aspects of Omori.
I also heard about To the moon, but games talking about disease are hard for me to enjoy
Final Fantasy X still holds my personal ugly-cry record. To this day, I can't hear some of the music from it without tearing up. It's one of those games that has emotional react videos on YouTube.
Shadow of the Colossus manages to be emotional with very little explicit story. A lot of it has to do with its use of dynamic music in an orchestral soundtrack.
Persona 3 just had a remake, and that's part of a series that can really gets its hooks into you. A big part of it is the parasocial gameplay, but even if you're not the type to get into that, the story is still very moving. Persona series composer Shoji Meguro recently said the ending theme in this game was his magnum opus.
Persona 3 is one of the "shorter" ones in the contemporary Persona series at a mere 60 hours. Persona 5 Royal is a beast, though. Hard to get through that one in under 100 hours without rushing.