I like Glenn Bateman and then Stu Redman.
I would have to go with the intro to "Night Shift" though I also like the intro to the 1989 edition of "The Stand".
Fear is a very relative thing. Often where we are in our lives (age, relationships, employment, education, life experience) has an effect on what we find frightful and what we don't. I read "IT" when I was a freshman in college and home for Christmas break 1986. He freaked me out at the time. I found the 1990 ABC television miniseries to be fearful as well - in particular the fist episode. I saw the first "Pet Semetery" in the theater in 1988 and it got me a few times. Most horror had a stronger effect on me when I was a teenager and in my twenties. Now, at 52, I find it doesn't effect me in the same way. If I engage in a horror movie marathon I do experience vivid and disturbing dreams so there is that.
I'm looking forward to it. I'm very curious to see how they do it a second time around.
It's the military that goes ape-shit in "The Stand". The cops are just overwhelmed or told to stay out of it by the Army.