Sex is sex. It's crazy, it's funny, and it's a general feel-good drug.
All-in-all, how much you enjoy it depends on numerous factors.
How you're wired, and what you're doing.
The person your with.
How experienced the both of you are.
How much your willing to communicate.
How serious about it you are.
Obviously, what I enjoy isn't the same as what you enjoy. As for what you enjoy? I don't know! Your body will give you a general idea about it, but it's up to you to experiment and explore. Of course, having someone open about it is just as important. Keep sex fresh with someone you care about.
Sex also is never going to be perfect on your first try. I'm serious. It takes time, and it takes someone you can talk to about. It tapes practice, but don't feel bad because you're not an "Alpha"[footnote]Fuck me that term's degraded quite a bit, hasn't it?[/footnote] or you haven't fucked 5000 women/men. Because that makes no different. Sex is only as good as how much you're willing to be with and communicate with the person you're with.
And finally? Never take it seriously. I mean, there are things you just don't do. (Rope around the neck is one, but that's when shit gets kinky~) But I'm serious. Our bodies are funny. Laugh it off, joke about it, and don't feel embarrassed. If your partner gets off, make sure that person helps you get off and that you enjoy the time you spent (Looking at you, ladies. Whip-em till he pleases you!)
Is it overrated? Depends on the person. Younger people are hard-wired to want/need it because that's how humans are built. As you get older, most people give less of a fuck. When it comes to sex, it's just about having fun and giving someone enough trust to make sure you feel good. It can be a great part of human interaction as, again, we're designed to crave and feel good when we get it. But, for a lot of people, why not just snuggle instead?