As a kid the following scared me stiff:
Salems Lot - was also 10 when I saw it! And yes the it was the scene with the kid at the window that flipped me out too.
Creep Show - Ted Danson zombie™

D) and the Fathers Day zombie really spooked me out as a kid, why was it I always had to walk home in the dark after watching these films at a friends!
Theatre of Blood - Vincent Price decapitating Arthur Lowe in his sleep had me hugging the duvet to my neck every night for a week.
Eraserhead - not sure if this is classed as horror but it certainly left me feeling very creeped out, a very surreal and bleak piece of work!
The Haunting - Not the pants remake, but the original black and white movie. I think this may have been really creepy at the time as a lot was left to your imagination. Good use of sounds and banging noises in the film to build atmosphere.
As an adult I would say my most memorable scares would be the end of Rec and The Grudge. Can't think of much else but would love to see some more cleverly crafted scary/creepy films rather than the glut of shockers and gore fests we seem to be inundated with these days.