Scariest? Bamboozled. I saw this recently and I thought I was going to be sick. I didn't even finish watching it. It made my stomach hurt, especially Damon Wayan's character. I shudder just thinking about it.
I watched "Salom's Lot" as a child and had such nightmares. I have rented it as an adult, but chickened out and couldn't even watch it. I just remember that boy hovering outside of the window and trying to get the other kid to let him in. And that green vampire guy?

Yikes! It's scaring me just thinking about it.