The Shining is the only movie that I can say has truly scared me. Great movie, but I can only watch it once, maybe twice a year.
Also, Paranormal Activity wasn't a horror movie, it was obviously a comedy. I was laughing my ass off through the whole thing.