The closest thing to horror games I've ever played is Dino Crisis on PS 1. Silent Hill I also tried but at that time, apart from being terrifying, it was also a bit complex for me.
Seeing it's sequel here gave me a shivering reaction hahaha xD. Honestly horror games are not my thing.