Most people don't believe in ghosts or witches or anything else like that, at least where I come from. So the fear is the pleasant sort, tempered with the knowledge the things in stories can't possibly hurt them.

And some people simply like to be frightened. There's a holiday dedicated to it, here.