At What Point Do Horror Experiences Become Un-Fun?

Many people love to be scared; it's absolutely a form of entertainment for them. But is there a point at which this fear becomes decidedly…un-fun?