I watched a hooky copy of the exorcist which I think was officially banned at the time, when my parents were out and I was far too young and I think a bit of wee may have come out when her head did the 360, but can honestly say that any "horror" film I can remember seeing since has never scared me as such.
The original version of "Patrick" certainly made me jump at the end, but I don't know if that would be classed as horror and I guess "Asylum" (70s film) creeped me out a bit, but again I was only about 10 at the time I saw it.
The scariest film related moment in my adult life was during "what lies beneath", not because the film is particularly scary, but because the electric in my house chose to go off at exactly the point HF pulls the fuse in the movie !
I find vampires films and all that stuff totally boring and/or laughable.