I am thinking about the guy who discovered the structure of the benzene molecule. He had a dream about a snake. The snake tried to bites its tale, so when he woke up he came up with the idea that the benzene molecule was a ring.
The dream I had was me sitting in meeting, trying to explain my interest in a CKM matrix so that I would get my name on a paper. The other authors on the paper were skeptical, and I was humiliated. That is why it was not a good creative dream. I was just being a careerist. (And no orgy either).