The only film that really scared me was one of the Terminator ones...the one where at the end he gets mashed up in all the machinery and the torso crawls towards the people...I was about 6 or 7 when I saw it and it really scared me...
That night I went to sleep dreading that he would jump through my window and brutally slaughter me and my family...