The Exorcist definately takes the cake. The fact that it is all real(true) is probably what makes it even more scary.
Another movie I found scary, but I saw it when I was very young, so it may not be as scary as I actually made it out to be, was Pumpkin Head II.