Dead Space is the only game that has really scared me. The dark atmosphere and the necromorphs movements are really creepy.
Among the Resident Evil series, only the original and 4 really were noteworthy especially REmake. I was much more surprised than scared though when an enemy would pop out of nowhere and attack.
Can't wait for Resident Evil 5.