Both Prey and F.E.A.R. have very tense moments to them, especially at the beginning.
But yeah, nothing beats old good RE horror. I just finished RE4 on Wii and now bought all five predecessors (RE, RE2, RE3, RE0 and Code Veronica) - this is how much I enjoyed it!