I don't think it's overrated. I've not enjoyed sex on occasion, but as a serial monogamist I far more often feel a great sense of wellbeing afterward, both of the chemical reward kind and the ego boost that is making a lady satisfied. I respect a guy who can admit he's not enjoying his sex though, given guys are supposed to be happy with just getting it even if the girl (or guy) just lies there like a sack of lame.
The whole guys want it all the time thrope is really grating, especially in media where a guy is super talented or passionate but his skills are written as a temporary substitute for sex. He's a master engineer only because he needed somewhere to put his energy after being ignored by women. Ultimately these people are fixed or humanised by a late in life sexual experience, and they inevitably bemoan all the time they'd wasted til this point not having sex.
I once heard a description of heaven whereby paradise is just a room where you sit forever holding an egg, but god makes it so that everything you've ever desired is in holding that egg, rendering you absolutely content to the point of having no interest in earth or the wider universe beyond heaven. All your needs have been met. I think sex for some people can be like holding that egg, only after a couple of centuries spent holding that egg they realize they're is no god brain hack which makes the egg seem more awesome than it is, its just an egg.
Sure there's some nice dimples and speckles that can be appreciated for what they are, but it hardly seems a fitting reward for a life well lived. Everyone else is smiling serenely at their eggs, there's must be different to yours. But then you wonder why everyone feels the need to turn to their neighbor and boast about the divine qualities of their egg, surely if holding the egg was that all consumingly blissful then you wouldn't be able to acknowledge anything outside it. If all eggs are equally great, and they are all great, why do people have to assure one another that they have great eggs? Why compare them? Why waste good egg gazing time pitying the people who don't have eggs? And you conclude then that all these other people must be lying. They haven't been hypnotized or enraptured by the egg either, they're just pretending because to admit the egg isn't working like its supposed to would mean they're broken inside or god didn't love them enough to reward them with an egg centered mind. So they all just sit there smiling blissfully, unwilling to call one another's bluff, all sighing and doting on eggs forever until one person stands up and declares they'll be leaving their egg while they go visiting upstairs to ask the Big Man about the big bang and free will.