I see my deceased brother come out of his room, and he was in a chipper mood, he even decided to show my little sister about Amiibos in Smash 4, I had a Samus amiibo in that dream to, I was thinking "No this isn't real" I felt like crying, next thing I knew, he was huging me tight, comforting me.
I know how you feel. I remember when my grandfather died I was little and I would start to see him in my dreams. The one that really got me was one where he hugged me and I told him I was glad to see him again.
Just this other night I saw a dream where I was send back to my elementary school and I would have to go through it all again...
I always have those dreams where I'm back at high school and I am late to class but I can't run or find my way around the school. Funny how your brain thinks it's real even though it should know that I'm not back there!
And yes, I think that dreams can be really good sources of inspiration for things. In fact, I believe that a lot of inspiration the author for The Strange Case Of Dr Jekyll and Mr Hyde had came from a dream when he was trying to find ideas for it.
I also think that dreams can sometime reveal things that we never knew we had. Not in a Sigmund Freud way, but I remember having a lot of strange dreams that were chaotic (even for dreamscape standards) during a difficulty part of my life. It was as if my brain was reflected the stress I was feeling even though I didn't physically feel it.