I've gotten misty-eyed at a lot of media, but no video game ever made me cry (like "balling my eyes out, ugly-faced tears streaming down my face" crying) until Spider-Man PS4.
The dad dying didn't really do me in. If anything I was kinda bored at that point, but the entire scene where Aunt May is dying and reveals she knew Peter was Spider-Man all along and you're just forced to sit through every grueling second, knowing that May has to die in order for the entire city and the world to be saved had me welling up. The following flatline and the funeral following after with the gravestone next to Ben were about when the waterworks really set in.
It's weird because I've never been that big a Spider-Man fan, but that ending was so unexpected and gut-punching, man. Persona 5 also comes in at a close second, though that definitely had a more upbeat light-hearted "things will turn out fine" vibe by the end, so it didn't really have that emotional oomph that Spider-Man PS4 did.