It is incredibly hard to make a scary video game. Too bad...
Only a few games have succeed to give me a scary feeling. Darkseed on Amiga was a chilling adventure and almost the same kind of story was seen in 3D 1st person view on a PC: Realms of the Haunting. Highly recommended!