I have a lot of sleep issues and I almost never remember my dreams. The last dream that I can remember happened months ago. My cat, Satanika, was a larger and more human-like version of herself in the dream and all I can remember is her telling me how she was disappointed in me. I know people think that dreams are significant and always mean something, but I am not going through the headaches and nosebleeds to decipher this one.
On other occasions, I have night terrors. At times, I've even sat up in bed - with my eyes open - screaming while I was still asleep. (My wife really loves me.) On the other hand, some of my sleep insanity has occasionally lent itself to a few extremely memorable experiences with my cute little wifey.
I have woken up kissing her, in the middle of a very heavy make out session with her, and even full on getting down to business. A few days ago, we were both on our sides facing the same direction and I woke up right in the middle of having an awfully good time. I passed right back out afterward. The next day, when she was asking me about what happened, I could barely remember it at first. After a minute I was like, "oh hell yeah, that was awesome!" I asked her about what made her initiate this little get together while I was sleeping and she told me that she was laying there trying to fall asleep and I just randomly started to have sex with her. She liked it. I suppose it's possible that while all of this is going on, I'm dreaming about something... but I never remember that part. What a great way to wake up!