In my personal opinion The Suffering is one of the most horrifying games i have ever played as a kid. As a 3rd person shoot 'em up game it has a pretty good story line and will leave you in fear.
You toyed with my heart and now somebody has to pick up the pieces