One of my favorite blues songs is "The Dream" by Robert Cray and Albert Collins. The lyrics are great and fit right in with the theme of this thread:
Last night
Once again I had the dream
I tossed and I turned
That old feeling's still the same
It was so real
I woke up cold and sweating
I wonder did I call her name?
In the dream she was right there with me
Right there with me in the bed
She said, "Bobby, come and kiss me"
"Never leave me!" is what she said
But when I reached out to hold her
Oh, I woke my wife instead
I hate when that happens.