I dream very vividly. Sometimes it’s very scary, and not at all a pleasant experience. But sometimes, just sometimes, I manage to get something out of the so-real-I-could-be-awake experience.
Just recently I was having such a convincing dream that I woke up and immediately wrote it down. A couple of hours later and I had the plans for another story. It was quite amazing.
I don’t know where my subconscious plucked the idea from in the first place, but it certainly turned it into something good. Perhaps it is worth having the horrible scary dreams sometimes, so long as it is made up for by the occasional dream that is inspirational.