As sad as it is...
The scariest movie I've ever seen was Jaws.
As a kid, I didn't go swimming for MONTHS after I saw that thing.
Lots of movies have "freaked" me out, "grossed" me out, "weirded" me out, but nothing, and I mean NOTHING ever flat out "scared" me like that movie did.
Jeff