Check out Shadow Hearts. It's a horror-themed RPG series for PS2, with great spooky story, interesting battle system(which is called "Judgement Ring" and implemented with QTEs), and enemy desighs right out of Silent Hill (basically, they are messed up, and descriptions make things only worse...in a good way). And there is also a Koudelka, spiritual predessessor for PS1.

All games(except for a SH3, which is a side story of sorts) are connected, so I recommend playing Koudelka, then Shadow Hearts, and then Shadow Hearts: Covenant. Covenant and Shadow Hearts 3, sadly, took a lighter route - less horror, more humor. And while Covenant still a great and spooky game, the third one got too "light" story- and atmosfere-wise; I think it can't compare to earlier installments of the series.