The first 3 Silent Hill games are all scary. All the Siren games are unnerving as fuck.
P.T. was one of the scariest games I had ever played, however that was only true for the first 45 or so minutes. After that it stops being scary and becomes just obtuse. Also, once you know how the game works and what its tricks are it loses all impact. It has no replay value.