The only movie that really fucked me up was "The Sixth Sense". At the time I was living by myself and my bedroom was pitch black at night. I was in bed after watching that movie swearing that dead people were touching me.
That and the Prophecy (old camp 80's horror flick) are the only ones that really freaked me out and quite honestly still do.
