I've always liked Silent Hill, but more for the mood of the games than the enjoyment of the gameplay.
I still think Resident Evil leads the way on that. Apart from the spin-offs.