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!
LiS is exactly what I came to suggest. I cried from every one of the LiS games and so recommend them all, but the original is hands down the best in pretty much every way.
LiS1 and before the storm were excellent, but my partner and I found LiS2 laughable and LiS3 downright cringy. :c