For me, I don't find it too terrifying to watch. Usually I'm a huge wimp, and am not really into the horror genre, but I'm okay when it comes to SPN. It definitely gets the adrenaline pumping, though. And, ok, it does scare the crap out of me sometimes. The other day I watched "Home" again, which is one of my favourite episodes, and was like "oh yeah, I remember why I loved this ep so much... it scared the pants off of me, what with the fiery thing in the closet and what-not."
I find that so far Season Two hasn't been very scary yet, I hope they do a really freaky one soon, I'm actually starting to miss the terror.
Although I did dream about zombies after "Children Shouldn't Play With Dead Things"
And the clowns... ugh... *shudder*
Speaking of "CSPWDT" (geez, even in acronym form it's long), I have to put in my weekly *squee*, since I haven't done so yet. So, here it is:
Dean. Tear. Dean! Tear! DEAN!!! TEAR!!! EEEEE!!!!!!!!!! *dies*
And Sammy watching porno! Priceless! I laughed my ass off at that. And Dean walking in and saying "Awkward" and then looking at the little brochure on top of the TV... OMG that killed me.
And, forgive me for misquoting this, because I can't remember the exact line, but "Man, the undead sure can run!" Oh Dean! <3 <3 <3