In a longer term relationship, I don't know that the intoxication would add very much - it might even take away. You don't perform as well, get tired faster and lose your edge. It can also dull your senses, so you might not appreciate what's going on.
Andrew W.K.