Sorry for being random, but this game is good?
I'm in the small minority of people who don't think it's very good, and not really scary at all.
For a few reasons-
1. The game isn't scary because you get spells fairly early on which allow you to restore your health and sanity by just walking in circles to build magic in a completely empty and safe room, of which there are many, for a minute or so then casting it. So I never had to deal with the "sanity effects" of the game.
2. Each area is recycled (with slight changes) 3 or 4 times so it started to feel really repetitious to me.
3. The monsters are mostly easy to evade and most of your weapons are melee, so you don't have to worry too much about them getting you or running out of ammo.
4. The mythology of the game, which lots of people seem impressed with, is wholly lifted from the works of H. P. Lovecraft with a few name changes. It's hard to overstate Lovecraft's influence on the modern horror genre but this is a straight pastiche of his Cthulhu mythos, and I would recommend anyone who liked it to read "The Call of Cthulhu" and "The Shadow Over Innsmouth" (my personal favorite) at least.
Just be warned that Lovecraft was, not all that surprisingly for a sheltered white Rhode Island man in the 1920s and 30s, a xenophobic racist and this often shows in his writing. Though he had started to broaden his views before his early death.
PS- I still need to finish the game, I just got really tired of the repetition about 2 levels before beating it a couple years ago and haven't gone back yet.