I think it may appear to be true for some people. I asked cac last night if he thought it was true for us "before." While he wouldn't use the the word "great," he thought things were fine except for the sex.
But I didn't, and my unhappiness went way back to before we were married. I wasn't chronically unhappy with our R, but there were things about the R that were problematic for me pretty much from the beginning.
And if one partner is not happy with the R in general, everything is not great. That's going to spill out in other areas of the R besides the SL. But because a bad SL looms so large, some HD folk may tend to not register other problems with the R because, to them, those things pale in comparison.
But I guess there are avoidant LD people, like Ms.HD and Mrs.Choc who might say that everything is great except for the sex (meaning except that their SOs WANT it from them).
Still, I think it's an illusion. So, my answer is no, it's not really true.