I've browsed the category on Steam, but my eyes glazed over after about the 10th page of Unity walking simulators, anime schoolgirls, and RPG Maker games with default assets. I'm also looking for something that'll really get under my skin rather than casual action-horror titles.
Examples of horror games (both old and new) I particularly like to give you an idea of what might resonate with me:
- Silent Hill 2
- Lost In Vivo
- IMSCARED: A Pixelated Nightmare
- Clock Tower
- Five Nights At Freddy's (I might catch some flak for this one, but it was a genuinely clever and well-executed premise before it got memed to death and I'll die on that hill.)
- ANATOMY
- Stories Untold
Horror games a lot of people seem to like but I don't:
- Doki Doki Literature Club (it was a bit too anime for me)
- Amnesia: The Dark Descent (I finished it, it was okay, never really scared me though)
Lone Survivor - a 2D Silent Hill-like story.
Oxenfree - quality psychological horror.
Penumbra (Overture + Black Plague) and SOMA - I think they're worth trying since the plots are very different from Amnesia, but if the gameplay is what you dislike about Amnesia then skip.
Oxenfree looks very interesting, as does Lone Survivor! I'll be sure to check them out.