The one movie that really scarred me as a kid was Poltergeist.
Problem with horror movies today is that almost every character in the movie is an unlikable douchbag. If you don't care for any of the characters then their is no tension when they are put into a dangerous situation. In fact you might actually root for them to get killed. That's when it stops being a horror movie and starts being a cartoon. This movie right here is a prime example of everything that is wrong with a horror movie.
After watching that is their anyone you would not want to see get killed?