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!
They probably aren’t your cup of tea but thought I’d add some more variety.
Final Fantasy XIV; an mmo with focus on story and the story arc from the past 9 years is wrapped up and brought me lots of tears.
Honkai Impact 3rd; ARPG gacha game (I know, I was skeptical) also with years of story following a relatively small cast of characters.