Patient Gamers

It might not fit entirely in, but check out Spec Ops: The Line. It's more or less linear shooter, but the story (and ending) makes it quite unique and very different from any other game I've played. Could too get pretty emotional at times.

You don't mind porn? Go and play the AVN Acting Lessons. It's on Steam. It's not too long but the punch it packs... it has this reputation of "the AVN you'll never wanna play again". I like to compare it to Requiem for a Dream.
If you want less heart-rending tears, I just finished chapter 3 of Being a Dik and there were tears, but the kinda good emotional kind. I'm the first surprised, but it seems to be a signature of the author and I quite like it.

Otherwise I'm playing Metro Exodus and man, that game is oozing with that uniquely Russian despair. No tears yet, but I'm preparing for some dark moments and the whole thing is just... wow. Mad Max had beautiful everything, but M:E has fantastic writing throughout. It all feels deeply personal and with that dreadful feeling of inevitability. And you only get to see/hear it if you want, mostly. Very glad I gave this game a second chance (it's very... clunky. Again in that typical slavic way, I guess; but it works if you accept it as it is).

Slime rancher always makes me cry at the end, but it deffo requires you reading the random notes and emails, and then also giving a shit about characters you never actually interact with. I can’t remember why it’s so emotionally effective, but this is the exact trap that keeps leading me back to replaying it and crying at the end again.

I played Heavy Rain and somehow managed to get the ending where everyone died. That kept me off gaming in general for quite a while. Brothers was mentioned here, I can recommend it too. Papo y Yo is a allegory of your relationship with an alcoholic abusive father, and it didn't make me cry outright but was pretty heavy.

How has A Plague Tail not been mentioned? Most of these mentioned a good games with a sad scene or two thrown in. Plague Tail, especially the sequel will make a grown man ugly cry.

The Vanishing of Ethan Carter! I'm not going to say anything, except that you need to do all the "side" quests. If you miss any, the map at the end will show which you missed. See the ending!

Dear Esther is also quite special, the monologues change every playthrough and everyone interprets the game differently. Very impactful.

I can recommend all games from SIGONO's OPUS series https://store.steampowered.com/publisher/sigono/#browse

Yakuza 0. That ending. Bruh.

My first thought is definitely Valiant Hearts: The Great War. That one, I found, to be devastatingly sad. Regularly on sale for super cheap, including right now. Also available on mobile if you prefer

Ori and the Blind Forest? I know it's not quite as mature as some of the things suggested here, but it really knows how to hit you hard at some points throughout the story.

Try SIGNALIS ! It is extremely depressive, emotional and evocative, and to an extent it is a homage to stuff like Silent Hill 2

The ending of metal gear solid three hurt me pretty good.

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.

S.O.M.A has a moment.

It was short and sweet but Planet of Lana got me in the feels a little bit.

The House in Fata Morgana. Nice thing is that'll it be both sad and happy tears.

It's been a few years and listening to the soundtrack snaps me back. I only wish I could I could play it again for the first time.

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

In Bindinc of Isaac you cry a lot.

But on a more serious note. The Life is Strange series can be very emotional, if you like the style of the games.

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