I haven’t tried my hand any creative writing stuff since middle school, but some dreams make me feel like trying to write stories again—so that I can (as you said) bring to life the interesting characters or worlds or emotions that I encounter/experience in my dreams.
Dreams with high-fantasy settings like the fairy or demon/angel one are especially inspiring to me. In contrast, when I have a dream like the one I did last night, which was relatively realistic/mundane (hung out with friends at a basketball game basically), it’s not even interesting enough for me to try describing/interpreting it—much less interesting enough for me to write a story inspired by its components.
So yeah, I totally get what you mean insofar as dreams providing creative ideas due to how otherworldly they are. Maybe one of these days I’ll get around to writing creatively again and take inspiration from a dream for a work.