i wouldnt say the game as a whole but just one mission in Vampire: The Masquerade Bloodlines is very scary and you have to play it for yourself to see because it really freaks you out. the mission is Ocean House Hotel and is the second thing in the game you are asked to do.
here is the walk...