Does Absence make the Heart, or just the Libido, Grow Fonder?

Long-distance relationships are the stuff of 15 seconds of fame: you scramble to get waxed, shaved, exfoliated, tanned, perfect hair/makeup/lingerie, your Kama Sutra and KY at the ready, and then bam! Suddenly it's all over and you're back to your boring existence, glumly counting the days/weeks/months(!) until next time. It is indeed like a live network broadcast - everything must go as planned. No fights, perfect sex, perfect activities planned for the next 24-48 hours, perfect food, perfect conversation, perfect weather, you name it. Expectations lie somewhere between Saturn and Jupiter, so God forbid anything goes slightly awry.
But what happens when you finally live in the same time zone, same zip code, same area code, same spot and he/she becomes part of your boring existence?