Sex God

A character (male or female) possesses In-Universe extraordinary prowess in giving physical sexual pleasure to his/her partner(s). A soft caress on the cheek from such a person can leave the subject a flustered bundle of sexual excitement, a body massage under their hands would be a heavenly experience, while the luckier ones who get to bed this character would most probably be in for the most intensely multi-orgasmic night they've ever had in their lives.

The reasons behind said prowess varies. Sometimes it's simply due to knowing "how to touch them right", sometimes it's through special sex techniques, sometimes it's by knowing how to make the best out of a larger than average tool, and sometimes it might be actual Magic. The Power Perversion Potential for this ability should be very obvious, assuming that it isn't itself a result of Power Perversion Potential. This an almost mandatory part of a Horny Devil's inventory of abilities. Many pornographic works tend to depict their male characters as this; for live-action ones, this would be an Informed Ability, given that they don't actually do anything "special" on-screen.

Note: This trope is neither tied to a specific gender nor tied to a specific sexual orientation. Also, being able to do one or two "tricks" to get one's partner hit the O-zone does not qualify for this trope. The character is supposed to be (hailed as) a veritable expert in carnal delights, not a "one-trick pony".

In The 40-Year-Old Virgin, Steve Carell's character finally breaks his duck with an as-expected three-thrust wonder. The action then cuts to some time later after his second performance and it's clear he's astonished his more experienced new wife with "natural talent".

Bond. James Bond.

Dr. Frank N. Furter of The Rocky Horror Picture Show.

In What Women Want the protagonist uses his mind-reading powers while having sex to find out what she finds most pleasurable, giving her the best sex of her life.

In the Earth's Children series, Jondalar is portrayed like this, due in no small part to his hardware and how well it and Ayla's own fit together.

The Destroyer series. In one of the books it's noted that Remo can use his knowledge of Sinanju to bring any woman to orgasm by touching her pressure points in a specific order.

Played with in the Film and TV series pilot. In the film Chiun claims to know the pressure points to bring a woman to Nirvana. When Remo asks him what they are, he shows Remo how to tap his wrist with a regular beat. Remo asks if that's the first point, Chiun says "No, that is how you know when the rice is done." and removes the rice that had been cooking off the burner. In the TV pilot, Remo tries the wrist-tapping on a woman and asks her if it does anything for her. It doesn't.

The female protagonist of the Jennifer Weiner novel titled, er, Good In Bed.

Any courtesan in Kushiel's Legacy, where the nation of Terre D'Ange reveres prostitution as a sacred act, but especially the protagonist, Phedre.

The main character and his mistress in Trevanian's Shibumi are level 4sexualadepts. The main character's favorite variant is where they sit/kneel at opposite walls of an empty room and try to make the other person orgasm first through sheer concentration. He later abandons it because of the lack of affection involved.

Anansi Boys - "He was part animal, part god, part unstoppable sex machine," referring to Spider who likes to party with the mortals.

In The Wise Man's Fear, the Fae Felurian is considered a sex goddess, leaving men as empty husks who soon die after she leaves them because they will never experience anything like it again.

In Dune probably every Bene Geserit would be this by default given that they can control their bodies at the cellular level, manipulate emotions, etc.

Daemon Sadi in the Black Jewels series, who was kept as a sex slave for several centuries despite his magical power and his incredibly lethal temper. He learned to weaponize his sexual allure and skills (e.g., pleasuring to the point of pain) so well that people began calling him "the Sadist", but that didn't prevent people from trying to bed him.

An episode of Seinfeld has a plot revolving around George and Puddy employing one of Jerry's "moves" for their girlfriends because it works so well.

Joey from Friends is sometimes portrayed as an extremely satisfying lover; so is Chandler after some coaching from Monica and Rachel when he dates one of Joey's exes.

At least twice in Season 4, it's suggested that Buffy's superhuman physical abilities translate to bedroom prowess; both her one-night stand Parker and Faith, who steals her body in a Grand Theft Me plot, comment explicitly on the matter.

In the final episode of Weird Science, Gary shows up with an alien girlfriend. Considering she looks the same as the rest of the weird-looking humanoid aliens of the species, nothing like a Green-Skinned Space Babe or Cute Monster Girl, Wyatt wonders what exactly he sees in her -- until he finds out just touching her hand feels so good that it causes him to do an ecstatic Jim Carrey / Jerry Lewis imitation. Apparently it's a feature of the species.

In the Conan the Roleplaying Game there is the temptress class. At high levels the tempress gains the ability to have such energetic and exhausting sex with a willing partner that afterward the partner will fall into a deep slumber where they can only be awakened by attacking them (or dumping a bucket of water on them). She is also so skilled at seduction that she can easily manipulate men into doing her bidding.

In Dragon Age II, Isabela claims to be so good in bed, she can turn even the straightest woman lesbian/bisexual.

Fallout 2 has the "Kama Sutra Master" perk. Given that there is one occasion where your "score" for sex has an effect, and only if Dump Stated physical attributes and charisma (an extremely unorthodox method of play), which prevent you from qualifying for it anyways, its a Useless Item.

El Chupacabra in Girly possesses legendary skills to please any woman (and practically every woman) he ever faces. The action itself is never shown, but the immediate aftermath, quite a lot. Generally the ladies are barely able to walk from all the fun their nerves had.

The Simpsons has Ned Flanders. He has sex once with a movie star who is in town to shoot a film. He tells her that the first one's free, but if she wants any more she'll have to marry him. She almost does.