I haven't played a good one, but even then I have only played a few. On the top of my head, 4 of them were ghost hunting games. Of those 4, only 1 was actually kind of scary but not psychologically or in a really creepy way, it just had a few jump scares.
I think for me personally, I love horror stuff and I haven't found my niche pick just yet. I really liked this HTML twine game called The Monastery, but as far as horror, it only has a few jump scares.
In my opinion, the atmosphere is very important in horror movies — the sounds, voices, the accompanying music, and the interesting plot are what matter most.