People already recommended some Final Fantasies, but really all of them can get you quite emotional at times.

If you like VNs, Umineko no Naku Koro ni made me cry so many times...

Edit: Just remembered Once on a Windswept Night, it's just a short game you can complete in a hour, but for some reason it made me really emotional.

Yakuza Zero has a story that is excellent, albeit goofy at times. In the end, it got me good.

Probably gonna get hate for it but I'm a man in my 40's and some of the Genshin Impact story lines have left me in tears.

They probably aren't your cup of tea but thought I'd add some more variety.

Final Fantasy XIV; an mmo with focus on story and the story arc from the past 9 years is wrapped up and brought me lots of tears.

Honkai Impact 3rd; ARPG gacha game (I know, I was skeptical) also with years of story following a relatively small cast of characters.

Last Day of June was also a lovely and emotional experience for me. I hope you'll enjoy it as well!

The most recent one to make me cry was...

"I Was a Teenage Exocolonist"

One I've not seen mentioned but made me bawl my eyes out is 'Presentable Liberty' Im not sure about the remake, but the original was pretty short and was gripping, despite the low level of action.

Final Fantasy X.

Lisa: the Painful

I dont know if its listed here yet.

Disco Elysium shattered me half a dozen times. Two moments in particular made me step away from my desk and go on a walk. It's the best-written game I've ever played.

Firewatch. Gorgeous, emotionally honest game that wrings you out.

Inside. More of a stressful, cathartic cry, but it applies.

Mass Effect 3 - but only if you play the first two. Incredible story that beats you over the head with yearning .

Golf club wasteland made me cry. It's a quick game, but I found it very touching.

Red Dead Redemption 2 made me bawl my eyes out.

Rimworld - Randy Rough