Usually its not too bad.
I have very realistic dreams sometimes though. There's been a time or two that I have dreamed something awful, like my children being killed or something like that, and it was so realistic that I woke up thinking it HAD happened. Something like that can put you in a funk...

Luckily that doesnt happen too often. :)