Basically what the title says. I've only played two games like this so far (Silent Hill 2 and OMORI) and am looking for more.
Could be games, ROM hacks, mods of existing games, etc.
EDIT: So many great suggestions! Getting a bit overwhelmed by how many there are, so I'm going to need to find a way to put this in some kind of list with an order to play the games in. By all means, keep 'em coming, though!
Spiritfarer. I loved it on switch, but it's also on steam.
"Spiritfarer® is a cozy management game about dying. As ferrymaster to the deceased, build a boat to explore the world, care for your spirit friends, and release them into the afterlife."
Spiritfarer is such a gem, one of the spirits you send to the afterlife really broke me. It's also available on Netflix Games so if you have a tablet and a Netflix sub you can try it from there.
It does such a good job of making you get attached to the characters. I cried for more than a couple of them. They don’t all end the same way too, and some are really heartbreaking.