Detroit: Become Human had a really great character focused narrative where basically everyone can die. Give that one a go

S.O.M.A has a moment.

Rakuen was the most recent game I played that did that for me

The Last Day of June is quite lovely.

Have you played Plague Tale 1 and 2? I'm not considered a very emotional person, but the dynamic really got to me. Just a really solid game, enjoyable combat. They're two of the very few games I binged to completion.

Mother 3 got me tearing up when I first played it

Had a quick scroll through and didn't see it anywhere yet, so:

Dear Esther.

Actually, reminds me I should play through it again, it's been a few years.

Rime is hauntingly beautiful in a way that hits you as it finishes.

Titanfall 2... Goodness that ending had my kiddo misty eyed. As for me, there was dust in my hand room or my allergies were acting up.

Tales, Xenogears

Telltale Games Walking Dead. Not a game, but a whole series.

Haven't actually played it yet but a video about MOTHER 3 made me cry just talking about the story (not only that but the part where he talked about the story made me a little emotional)

Here is the video btw

You may already know it but Omori was heavily inspired by the mother series and especially Mother 3: https://twitter.com/_omocat/status/1384687971929006080

Death Stranding

Papers, Please. Maybe not crying, but could definitely put you into a depressed mood if you manage to get into character. Needing to make a choice between letting some poor bastard's wife follow him without proper papers and feeding your family is tough.

Persona 4 Golden is a beautiful game that made me emotional more than once.

Portal 2. But you should play the first part before sequel, if you haven't already.

That Dragon, Cancer. Part game, part visual novel.

Final Fantasy X.