I enjoyed sleeping, but I don't know if you could say that I got excited about getting to sleep. For me, dreaming is like starting a new book - You don't know what you're getting into until you've started it, except it's a great deal harder to reread a dream.
I actually can't get to sleep if I'm excited or concentrating on falling asleep. Before I learned tricks to falling asleep, I generally let my mind wander while lying in bed. I enjoy thinking up stories for books, and when I get a particularly good idea I keep following the idea, which I get excited about and it makes it difficult to be calm enough to actually get to sleep. So excitement about getting to sleep right before getting to sleep is a bit counter-intuitive for me.
I never thought about making a direct connection between events in a day and the frequency of my dreams, though. I tried the dream journal experiment as a young teenager, and I was a pretty happy, healthy young man, so it could have had some major effects on my dreams and their frequency.
I wonder if that could be reversed. Good moods can produce dreams, so could dreams produce good moods? I may try the whole experiment over again to test that out. I could see if encouraging dreams and remembering them can help with stress. Dreams are already beneficial for us, so they could be improved to become more frequent, thus relieving more stress (In theory). I imagine most stressed adults don't dream much, so encouraging dreams could help manage stress. It could even snowball, since a person in a good mood dreams more, they get in an even better mood. Though, like most matters of the mind, I think it would need to be trained to do something like that.