Bruce Wayne (Batman) has been described as this by a couple of his lovers. Selina admits he's great in bed, Talia has described him as "magnificent" and Silver St. Cloud claimed he gave her eleven orgasms on their first night together.
Talia Al Ghul: Talia's a skilled seductress and is sometimes portrayed as a very satisfying lover.
In a flashback to her time "imprisoned" by Darrk attempts to intimidate her by threatening to make her a Sex Slave until his men tire of her, she's completely unaffected and merely tells him no men would ever get tired of her.
Prince Charming from Vertigo's Fables is universally hailed as this. Whatever his other shortcomings, even his most hostile female detractors cannot deny his phenomenal carnal prowess.
Green Arrow: Oliver Queen relationship with Black Canary has been a tumultuous one, with many of his flaws often driving Dinah Lance nuts, but one thing she never complains about is bedroom prowess, as Oliver has consistently been portrayed as a satisfying and selfless lover. To the point it's a Running Gag that he gets her to release loud sonic orgasms and she once quipped that him talking is her least favorite use for his mouth. DC writer Creator/Kevin Smith once joked that "Oliver Queen just knows how to make the ladies quiver. Especially when he hits the bullseye."
New Gods: Kay Fury (Knockout) 's called the "Goddess of Sex and Fighting" for a reason. Both Scandal and Deadshot have talked about her being a very skilled and aggressive lover. She's even joked this is why she's called Knockout.
Played With in Red Hood and the Outlaws. She walks out of a brothel tent, claiming the men inside can barely after she got through with them... only for the owner to walk out, claiming that she poisoned them.
Koriand'r/Kory Anders/Starfire's often depicted as an extremely satisfying lover. Nightwing once joked he wouldn't be able to walk for a few hours after they slept together and Captain Comet describes having sex with her as "Earthshaking" even though they were on space at the time.
When Barbara Minerva ends up sleeping with Snapper Carr in Final Crisis Resist, he's completely overwhelmed by her sexual prowess, while she smugly the exhausted Carr "Yes, I'm very good, I know.". It's suggested it's one of the perks of being connected to a Fertility God.
Sexual love is still one of Aphrodite/Venus's domains as a goddess, and she's hinted by Ares to truly be a lover beyond compare.
Zeus, according to Hippolyta's narration to Diana's conception.
Atlantiades/Hermaphroditus mentions to Maggie that a casual hook-up with them would ruin her for any future lovers.