I too love emotional games. Here are my personal favourites. Some of these have been recommended by others but idc:

What Remains of Edith Finch - as Edith Finch, you go back to the house you grew up in and explore your family’s history. The Finch family have had much misfortune, and many did not grow old. As you explore the house room by room, you see that person’s last moments. I cannot recommend this game enough. It’s only 2 hours long and best enjoyed in a single sitting.

Life is Strange - you (Max) have recently returned to the town you grew up in for a prestigious art programme at the Blackwell Academy. One day, you discover you have suddenly gained the ability to rewind time. In this game, you explore your powers and reunite with your old childhood friend, Chloe. Don’t worry too much about the superpower thing, it’s without any Marvel BS.

Detroit: Become Human - in this game, you explore a world where robots are servants to humans from the POV of three robots. There are three stories that you follow that do meet each-other at some points. Not all stories are equally exciting, but two of the three are pretty great imo. It really makes you think about what it means to be human.

Kentucky Route Zero - this is an odd duck that you may enjoy as well. You start as Conway, an old man driving for an antiques shop doing his last delivery, as the shop will close down soon. As you try to find your way, a gas station attendant gives you cryptic directions to Highway Zero. As Conway and several other characters, you explore the surrealist world beneath Kentucky. It’s a game filled with mystery, grief, loss, and being lost. This game is more like a strange dream rather than a videogame, and is therefore best played in the later hours of the day.

I hope there are some interesting picks here for you. Enjoy!