I think in a way, sex is overrated if we're focusing on the physical pleasure. It's incredibly intense but the feeling subsides afterwards (at least for men I've heard). I used to enjoy sex but after having dabbled in some recreational drugs (ecstasy, opioid painkillers), I would say that they offer far more pleasure than sex.
The intimacy from sex however is not comparable to anything else.