The original THE THING (1953, IIRC) – the entire movie isn’t scarey per se, and certainly not compared to modern movies. But it has one moment that always makes me jump out of my seat, and I’ve seen it half a dozen times.
One of the more recent films that really did a number on me was The Descent. Damn near lost it during one particular scene, and I will never go near a cave again.
If you speak Spanish or if you don’t mind reading subtitles, The Devil’s Backbone and The Orphanage bring the creepy.
See, I totally get what you mean about the last scene. I got that chill when I saw that last scene in the theater. But it’s the preceding tedious 90 minutes of people walking around lost in the woods and shouting at each other that makes BWP crap. 
I’ll give another vote for The Descent. Very creepy.
And check out the Spanish movie REC. It’s a low budget “found footage” shaky-cam type movie, but–unlike BWP–stuff actually happens. The final scene really freaked me out! (BTW, I have not seen the American shot-by-shot remake–Quarantine–or the sequel to the Spanish movie, REC 2)
See I don’t get why people think nothing happens - as other dopers in this thread have said, the spooky noises outside their tent, the piles of rocks, the hanging stickmen, the slime. After I watched it with my now ex boyf he said he didn’t find it scary, when I asked him about the noises, the kids laughing and such he said “what noises, I didn’t hear anything?” You need good sound on your telly to watch this film 
BWP is a great ghost story where everything ties in neatly and the actors are believeable. It’s one of my favourite horror films.
Ok, I think the scene which most gave me the chills the most was in the movie The Innocents, where we see across the lake the woman in black standing there staring, we see it, the nanny(?) sees it but no one else does and we know the nanny isn’t crazy.
Also Paranormal Activity is great, really. It turned me into a nervous wreck.
I second Carpenter’s *The Thing *as well. There’s that one scene that made me jump the first time, and I’m pretty jaded about horror flicks. Ever since then, I play it for my friends and almost every one of them has jumped.
Besides, it’s a great film. Love the ending.
There’s another one that I want to mention, and for a while I thought it was *The Descent. *But it’s not. I re-saw that one on SyFy the other night, and while the chicks crawling around the cave was cool, it wasn’t the one I thought it was. The one I’m thinking of has the same theme, but there is at least one guy in the cast. I don’t want to ruin it, but I can’t spoiler it because I don’t know that much more about it. But the ending there was quite good.
I loved BWP as well. The camping scene with the tent always reminded me of camping as a kid when the others would try to freak out the tent-dwellers by shaking your tent. Even though we knew who it was, it was usually scary. More often than not, this was accomplished with a cohort in the tent telling some sort of pre-rehearsed story.
The Strangers. Watch it alone, in the dark, with a great sound system, and you’ll spend the next week hiding under the bed.
Two nominees:
-
The Zuni fetish doll segment from Trilogy of Terror. Everyone cites that one, so I will add…
-
Wait Until Dark - Harry Roat, Jr. is one of the most terrifying characters ever written. Alan Arkin was chilling in the role, as was the local guy I saw in summer stock a couple of years ago.
One of the few movies to permanently mess me up was Funny Games. German version or the American version, it doesn’t matter because it’s the underling premise of random acts of extreme violence that gets to me.
The final scene in Blair Witch got me–I hated the movie until then. The final scene–well, I screamed, and jumped up, and ran down the hall and locked myself in the bright, small, shadowless bathroom.
Some of the X-Files episodes got to me–Home, with Andy Hardy, and others.
I don’t think the ceiling-walker scene is in the original Excorcist–is it Exorcist 3? It is creepy as hell.
Loved “The Changeling.” I like the movies that take their time, and build up the suspense. I find that with the original European movies of “Let The Right One In” and “The Vanishing”. Slow building, gradual creeping dread…
The Descent? I will never, ever, ever approach a cave. Like darkness, icky insects in the dark, and claustrophia weren’t enough!
I love October. It’s Scary Movie Month!
The ceiling walker scene is in Exorcist 3, and is creepy as fuck. I was watching that with my now ex-hubbie, he had fallen asleep on the couch, and when that scene came on, I shook him violently and forced him to stay away for the rest of the move.
The spiderwalk scene is from the original Exorcist. Here is a link to the scene, I think, because I’m too chicken to watch it and make sure it’s the right one.
The creature things in The Descent get my vote for creepiest non- supernatural creepy thing in a movie, EVER. And they were created with very little effects and no cgi.
The most recent movie to scare the crap-a-doodle-doo out of me, was The Burrowers.
The original Halloween. Very little blood, really, but lots of psychological torment from the constant stalking even before the home invasion.
Paranormal Activity bothered me tremendously. That’s what I get for watching it at night.
The Orphanage (El Orfanato)is both one of the creepiest and smartest ghost stories I’ve ever seen. It’s not a jump-scare-behind-every-door type film and there is very little violence or gore, but the atmosphere of the whole movie just gives you that tense feeling of dread in the pit of your stomach.
A Tale of Two Sisters is probably the creepiest movie I’ve ever seen. It’s pretty weird, though. Not one I’d necessarily recommend.
Event Horizon was also incredibly scary and was a damn fine movie, too. It gets pretty gory at times, but has some wonderfully creepy moments. I’d say it’s my favorite horror movie (not that I’ve watched a huge number of horror flicks).
Lost Highway freaked me out the first time I saw it, in my room at night all alone. I think I was 16 or 17. 8MM, also - I watched it with my dad when it first came out, in a very small old theater (Von Lee) which unfortunately was torn down. The older and smaller the theater, the scarier the movie.
Aside from that I’m not sure I can think of anything.
The Haunting. Yes, it’s “old”, and in black and white. It still scares me to death, almost as much as the book did. It’ll be on TCM on Halloween night.
I saw the original Ringu before it was remade in the U.S. Cool flick, but not that scary.
A little while later, I was visiting my future sister-in-law’s house. She had three kids, and it was a sort of a dry run with my fiancee to see if we could do the family thing successfully.
Eldest daughter had this awesome Spongebob animatronic alarm clock that she proudly showed us before it was kid’s bedtime.
With the children out for the night, me and the future wife watched her sister’s dvd of The Ring, in the living room, on the inflatable mattress, right in front of the big tv. Cooool. It was well done, and fairly creepy. After the film was over, we snuggled a bit for comfort, and went to sleep.
About twenty minutes later, the Spongebob clock went off.
Full blast, with lights and sound. Maybe a foot from my head. And I was sure the tv was about to eat us. So, yeah, The Ring.
Audition, on the other hand, is the only film where I just said “I can’t see anymore, this is too unpleasant, aw christ, why am I watching this?”
Prince of Darkness. While The Thing was very action-oriented, Prince of Darkness is quite cerebral and always leads to a discussion, particularly about the “dream” (This is not a dream… not a dream. We are using your brain’s electrical system as a receiver…).