Don't think I've seen anyone mention Oneshot. Amazing little game.
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.
If you like VNs, check out Saya no Uta. One of the most fucked pieces of media out there. It's amazing.
Plague Tale (Both games are solid, but 2 was sooooo good)
Telltale Games Walking Dead. Not a game, but a whole series.
That Dragon, Cancer. Part game, part visual novel.
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.
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.
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.
Death Stranding
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)
You may already know it but Omori was heavily inspired by the mother series and especially Mother 3: https://twitter.com/_omocat/status/1384687971929006080
The most recent one to make me cry was...
"I Was a Teenage Exocolonist"
Patient Gamers
A gaming community free from the hype and oversaturation of current releases, catering to gamers who wait at least 12 months after release to play a game. Whether it's price, waiting for bugs/issues to be patched, DLC to be released, don't meet the system requirements, or just haven't had the time to keep up with the latest releases.
^(placeholder)^