Vampire blood lines, only played it once, never completed it and it's probably quite dated now but it was an excellent game.
Agreed, I havent played many of the other games mentioned here but I would be willing to bet this is the scariest

The rest of the game isnt actually that scary, but in Santa Monica when you enter the haunted hotel, just this level makes it the scariest game I ever played
