I can add my own "Debbie Downer" perspective :-)

...Literal, nighttime dreams are coded, subconscious processing and desires. You may be getting a wrong read on them.

Daydreams, or lofty desires and ambitions, are still part of the fantasy world. They may be coming out of some deeper, unmet need, compuslsion or insecurity.

If they are about self-interests, (like the perfect mate, car, home or job), then you may realize they're really moving targets- leading to further desires and dissatisfaction (or "dukka") after achieving them.

I tend to think if you have a vision of how you can improve the life of others and the world around you, then you may get some long term, spiritual fullfillment from actualizing them.
JMHO