For me, it was Princess Rosalina’s backstory in Super Mario Galaxy.
The end of Red Dead Redemption. Spoilers for a game that’s over a decade old, but John’s death was a brutal cruelty that stayed with me for a long, long time.
After everything you do in the game to get Abigail and Jack back, and to see John get to be happy and enjoy his ranch in the final act to it being tragically cut short. I know a lot of people don’t like playing as John in the RDR2 epilogue but I felt like it gave me needed closure from Red Dead Redemption
The sequel was even more brutal. I cried like crazy at the end of both games. Like full on sobbing into a paper towel bc tissues weren’t going to cut it crying.