What an epic story, Platypus!

I've experienced situations where my sexual lust and desire for another have gotten me through difficult times, such as illnesses and mental breakdowns. I've been known to counter stomach aches and nausea with sexual fantasies. For some reason, the stimulation subdues mild to moderate stomach pains for me.
There was once a pharmacist I had the pleasure of meeting when dropping off/picking up a prescription. It took about fifteen minutes for them to process it, so I sat in the lobby doing none other than fantasizing about the handsome pharmacist.
He was a kind looking man with a lean, athletic body and a unique, cheerful face. Dark hair and bright eyes. I almost immediately began thinking about the two of us being in a relationship. This fantasy of a relationship escalated into living together, buying a house together, raising a child together and having a lot of intimate moments and, yes, a large amount of fervent lovemaking. I think imagining the two of us in a realistic situation with our own problems and even arguments and fights made it that much more enjoyable.
So, in short, I've found my feelings of affection for others to be intensify when I'm considering the "bad" things, too, or those parts of life that are maybe better described as undesirable yet necessary and appropriate to the wavering fabric of human life. The good and the bad contrast, weave and combine in a way that create a whole that is sometimes more enjoyable and significant as the whole it is than the parts that make it up when examined separately. This isn't always true, though, as lust and only lust or admiration and only admiration and many others can be completely unique and enjoyable experiences alone. In fact, I find it's these stronger emotions and feelings that come out on their own that influence me more easily than combinations. Combinations can confuse me or take me longer to process sometimes. Anyway...
When that pharmacist called me to grab my prescription he had prepared, it felt like a large amount of time had passed, yet it was only about twenty minutes or so. His face lingered and I felt kind of intoxicated by my fantasy of a life with him. In a way I experienced something similar to what you did, Platypus. The unattainability and the creativity going on in my mind made it so delightful, yet it probably wouldn't have turned out like I imagined it if we were to live a life together, even considering the flaws I calculated in.