Four games come to mind.
Death Stranding.
Discovering that Cliff was Sam's father had me in tears. Not to mention the ending, where both Sam and you, the player, are forced to march up to the incinerator because you think Lou/BB is dead. That did not close the floodgates.
Titanfall 2.
BT-7274 dying in the end and tossing their pilot to safety so he wouldn't die with them broke my heart. I got so attached to that mech in the game that it wasn't funny.
Cyberpunk 2077.
Jackie's death broke me after the segment where you get the Johnny chip. Just hearing V saying goodbye to him arguably made it worse.
Red Dead Redemption 2.
Getting Arthur to high honor and hearing the positive things people said about him in his final ride back to camp had me crying.