I watched as a kid. I think it depends on the person. My best friend slept soundly. I did not.

If you're looking for something more in the vein of "Are You Afraid Of the Dark?" but more towards comedy, I suggest "Eerie, Indiana."