Manhunt had the tendency to make me jump a bit. Hardly a Horror game though.

Tombraider was a scary one. You're completely on her own, running through the dark, then a giant Tiger jumps out and Mauls you. Bound to scare a few people (me).