I've also yet to have a dream that can overwhelmingly shift my perspective and motivation. An LSD trip made me "take the risk" and move continent with no support to be with my girlfriend. I say "take the risk", because I can just walk into any police station and get my ass deported and land right back at my parents house. Everyone thought I was crazy, but LSD made me see the real probability of risk in that it was negligible.
Mushrooms made me motivated to lose weight. I remember standing in my bathroom naked looking at myself and I came to the conclusion I wanted to be in shape for my son.
Another mushroom trip made me reevaluate risk and see that I have to start my own business. In fact, I just registered a business name and got insurance so I can get licensed.
Funny that dreaming did none of this for me.