It is exactly as you described. Nobody can ever understand it until they experience it. Comparing it to the matrix might do it a little justice. But there are limitations -- waking up, falling back into non-lucidity, false awakenings and so on.
The first lucid dream I had was glorious. I was dreaming about being on a very tall grey building with overcast skies, on a wooden deck protruding from the side of the building. I became lucid and commanded the sky to crack with lightning and it did. I flew upward and created a swirl of clouds and was generally having an amazing time. This all was as if it were completely real. Then, too excited, I woke up. But it was a terrifying false awakening where a black figure sprinted toward me and attacked me. Then I woke up for real, absolutely terrified. It was so scary that I decided not to lucid dream anymore. But with recounting all of this, and thinking about it for the first time again, I think I might start doing it again.
I never consciously do reality checks, but I'm a very inquisitive and skeptical person. Easily distracted by cracks in the wall type.
I wouldn't let one bad experience stop you from lucid dreaming :( . I might be an outlier, but my experiences have been overwhelmingly amazing. Yes, I still have nightmares are the lucid ones are waaayyy worse. But lucid dreaming is such a great experience I would never wish it away
Self-aware nightmares are way more terrifying than the regular variety, a lucid dream where I sometimes can't take control. I usually try to wake myself immediately, but sometimes this leads to repeated false awakenings. The worst I remember is 5 false awakenings before waking up for real.