What is a dream? I hardly ever dream. In fact I can't remember the last time I actually had a dream, it's been at least several months. When I do they tend to be uncomfortable or scary.
Although I do have memories of a few dreams that were quite nice. My desires were instantly gratified, I was powerful and perfect. I'm not talking about sexual stuff either. I was just content with myself. I think one of these positive dreams was of me teaching philosophy to students - I did not stutter like I do in real life, I did not get anxious or nervous. I was in my element and the students apparently loved me. It was nice.
Reminds me of the Freudian theory of dreams. Freudian psychoanalysis has a complicated reputation, not altogether positive, and for good reason. In fact his theories were essentially "metaphysical" despite his protests to the contrary. An interesting theory he articulated what that dreams were the method in which the unconscious seeks satisfaction. When we are conscious, we are given these needs and desires that throw us into a state of discomfort - the real world forces us to make choices and relegate resources to accomplish our goals. In a dream, however, we're not dealing with reality. We effectively make reality and because of this we can sometimes have very pleasant dreams in which the desires the unconscious produces are instantly gratified. There are more details, mostly related to time, that aren't entirely dissimilar to the metaphysical speculations of Schopenhauer, but I can't remember them right now.
Freud's meta-psychophysics might not be entirely correct, but it certainly makes it all too evident how the dreams we experience are sometimes better than the reality we live in. It's a metaphysical scheme that, like most metaphysical schemes, tells a story with a moral, which is more important than it actually being factually correct. It makes me wish I did dream more.