I have never got scared in a middle of lucid dream, but the hallucinations during sleep paralysis can freak you out good.

Like with most things, any fear you may feel will diminish the more you experience it.