For me it is extremely rare, maybe a one time in 5 years occurrences. I had one recently, where I suddenly realized I am dreaming. So I was at "school" (I'm 29) but as always when I'm dreaming, I never question anything. But somehow I did, I was awake for like 1 second, so I just started throwing glasses around, but people barely reacted. All my dreams are extremely creative and extremely random and theoretically possible, but not really. In places I've never seen before, buildings that don't exist but aren't that weird, very creative and strange plots, etc.
I really don't know how my brain can come up with such ideas and plot-lines. Just one scene from a dream: I'm in a mall, and I have to order pizza at the counter. The wall behind the counter is filled with different pizzas, hanging there like paintings. There's only 1 of each pizza, and everyone is ordering at the same time. But the place is more like in some random mall. The dream then develops further becoming even weirder. This is not at all creative, it is just the dream I had last night.
I will also never have the same dream, and always I won't realize that I am dreaming despite it being absolutely illogical or a certain place or building not existing. If I don't coom for like 7-10 days, which is extremely difficult for me, I would start having dreams of engaging sexually with girls, some my mind just makes up.
I'm never creative in my waking state. And I never realize I'm dreaming, no matter how strange the dream is.
