Later done with Negi, who was infamously a Memetic Sex God even before becoming a Vampire. It's left open whether he'll continue aging for a couple years before eternity sets in and halts it, or simply become male Legal Jailbait.
In The Tomb of Dracula, the Count assaults attractive women in every issue, and the act of biting is often described in sexual terms.
Played straight with Ragamuffin, who is drawn as a very attractive Tall, Dark and Handsome male by most Lenore the Cute Little Dead Girl fans. In the original comics, this is not quite clear as all the characters are caricatures, although the eponymous Lenore is mentioned to be extremely cute, in spite of her quite grotesque, morbid traits in the original comics. This implies that both Lenore and Ragamuffin would be beautiful if they were realistically portrayed.
Vampires in Life Sucks aren't necessarily any better-looking than humans, but with the ability to cloud the minds of others comes the potential to force others to fall in love with them. The protagonist describes it as glorified date rape.
In The Unwritten, after Richie Savoy gets turned into a vampire, he apparently has lots of sex with gothy vampire groupies. (Helped along by the fact that he's outed himself as a vampire in a bestselling book.)
NGE: Bloodlust has Rei becoming a vampire. It makes her a borderline nymphomaniac and Maya gets herself off by being fed on by a vamp. Do the math.
The 1979 film with Frank Langella was really the first attempt to deliberately present Dracula as a romantic and attractive figure. When the film was being made it was mentioned that Dracula being attractive was actually to make him more terrifying in a way; it effectively hides the monster underneath and at the time was quite novel, to mislead the audience. Practically all the reviews for it on the IMDb talk about how sexy Langella was in the role.
Vampires from Twilight never get tired, never have to eat, never have to go to the bathroom, and (apparently) lack a refractory period, since they never stop. That doesn't mean they can't get people pregnant, of course...
Older Than Radio: Just about everything to do with Bram Stoker's Dracula being thought of as a sex god comes from him being a metaphor for sex, at a time when sex is viewed as completely repulsive and subversively fascinating at the same time. He's not physically attractive (the Count is described as having a big, beak-like nose, a unibrow, and hairy palms), but there's still something irresistable about him (hint: it's probably supernatural mind powers).
Carmilla from the Sheridan LeFanu story of the same name is a classic example.
And before her, Clarimonde from Theophile Gautier's "La Morte Amoureuse".
As well as the vampires in Vampire Diaries, of the same author
An entire bloodline of vampires are this in Anita Blake: Vampire Hunter, due to the powers making them Horny Devils, up to the point that they are (in-story) the inspiration for succubus and incubus myths. It's implied, though, that everyone except the "good guys" aren't above just grabbing some random person and draining them dry every night. Apparently, "hiding kills from the authorities" is a bloodline power of every line but Belle Morte's.
This is pretty much a rule on the Disc. In Thud!, it is commented that female vampires look stunning in just about anything, and that, unlike males, they can't reform their clothing when changing back to their human form, 'probably due to all that underwired nightdress business.'
Subverted for laughs in Reaper Man with a pair of overweight, middle-aged, Morporkian vampires who'd certainly like to be sexy and elegant.
And the Countess isn't even a vampire proper - she's just pretending because her husband inherited vampirism with the title, well past the point where biting the missus was likely to happen.
Lady Margalotta is described as a reasonably attractive middle-aged woman, who dresses in fuzzy pink sweaters.
Hell, poor Thomas can't even hold a job slinging burgers, because the women on staff keep trying to molest him in the break room!
The Red Court vampires also get a dose of this. Suave, sophisticated, and more than a little drop dead gorgeous — and on top of that, their saliva serves as a potent narcotic with euphoric properties. Mind you, the sexiness isquite literallyonly skin deep...
The Black Court though....nope. Not at all.
The male vampires in novels by Chelsea Quinn Yarbro are dead below the belt, and compensate by being cunning linguists.
Bloodsucking Fiends by Christopher Moore. Tommy's response to discovering that his new girlfriend is a bloodsucker? "That's the coolest thing I've ever heard. Let's do it with our socks off."
From book to book, P.N. Elrod can't seem to remember if her male vampires are able to engage in conventional intercourse or not, which is kind of embarrassing. Her female vampires definitely can, however, and in books where the males are impotent, a little neck-nibbling and heavy petting usually gets the job done.
Potent or not, Jack and Bobbi can barely refrain from getting it on for five minutes at a stretch whenever they're alone.
Upping the Squick Quotient, the protagonist of S. P. Somtow's Vampire Junction often feeds himself by picking up horny men in the red-light districts ... and he looks ten years old. Guess if you gotta kill somebody ...
Similarly, all the vampires we see in the short story Venus and Mars (besides one mook) are beautiful young girls, all mostly ex-child prostitutes. They have a fairly successful racket going on.
Depicted in an interesting way in Barb Hendee's series, starting with Blood Memories. Vampires project a hypnotic aura that varies depending on the personality type they had in life. Someone who was naturally sexy and appealing will be able to easily attract human prey, whereas someone who came across as intimidating or creepy in life can paralyze victims with fear. Other vampires in the series give off an "innocent and helpless" vibe that draws in people who want to take care of them or take advantage of them, or an aura of charm that makes that vampire seem naturally charismatic and likable.
Larry Niven plays with this trope in the Known Space universe. There is a group of Human Aliens called Vampires living on the Ringworld which drink blood as their primary means of sustenance. They emit a pheromone capable of seducing any humans or other Human Aliens that they encounter and then drink them dry during sex (luckily, our hero has befriended a tiger-like alien who cannot be harmed by the pheromones). However, the Vampires are also non-sentient, possessing about the same intelligence level as a monkey. Some perverted Human Aliens use defanged vampires for sex.
Ivy and Kisten from The Hollows - much is made about both characters' sexual prowess throughout the series.
This seems to be a universal rule for vampires in the Night Huntress series. Their venom acts as an aphrodisiac and they have centuries of experience to back it up with.
Though only two vampires (Bones, with his experience as a former gigolo, and Annette, whose visits to gigolos in the eighteenth century indicate a general horny nature) have ever been commented on in this manner. Also, the implications of having sex with undead people were joked about once or twice (in the scene where Cat's boss and her team are pointing out that her relationship with Bones makes her a necrophiliac, and she points out that a number of them have expressed interest in screwing her, and since she is a Dhampyr, that means they are all necrophiliacs too).
Vampire Willow is actually an aversion. In one of her scenes she is torturing Angel, who in his time was considered by many as a true picture of viciousness. Willow as a vampire is so far beyond that Angel's squirming in fear, before she plays sex games by slowly burning him alive.
Seen in the opening two-parter — Alpha Bitch Cordelia won't give Jessie the time of day until he becomes a vampire, whereupon he suddenly becomes more assertive, darker, and sexier.
This is actually Lampshaded and Justified In-Universe. Vampire blood is prized for its healing powers and is often used as a recreational drug... with the side effect that it gives you vivid and intense sex dreams about the vampire it came from.
It's implied in The Vampire Diaries. A vampire friend tells Stefan that if he wants Elena to love him, he should just give her a taste of "awesome vampire sex." Stefan admits he wants to, but refrains because he wants her to "have a choice." Thus, it is implied that not only is he a supernatural sex god, he's also a romantic idiot.
Ian Somerhaulder plays one of the vampires on the show. Enough said.
Let's not forget Katherine, Vicki, Caroline, Rose, etc.
Basically every vampire on the show.
Any vampire character who turns up in Professional Wrestling will be either the standard freakish sort (more common) or this trope. The "sex god" archetype was played to the hilt by Gangrel and Edge (yes, thatEdge), who were hot blond studs who also just happened to be vampires.
Helen Magnus has yet to be convinced of this. The fanbase, on the other hand, has embraced Nikola Tesla - he with the constant plans for world domination - with quite a passion.
Rory in My Babysitter's a Vampire subverts this, he has even worse luck with the ladies than Ethan and Benny, and that's saying a lot.
Played straight with Erica and Jesse though.
Parodied in Supernatural when Dean, while hunting vampires, runs across a teenager who wears fake vampire fangs to pick up girls.
The X-Files: Agent Scully repeats many times in "Bad Blood" that she doesn't believe in vampires, yet she admits they're supposed to be extremely charming and seductive creatures. She was completely dazzled by Sheriff Hartwell who happened to be a real vampire.
Young Dracula: The only unattractive vampires that have been seen are the Westenras,
In Bram Stoker's Dracula, one of the animated displays has Dracula seducing and biting a woman, to which she moans in pleasure.
Vampire: The Masquerade has the Toreador, Anne Rice-style vampires who stick close to humanity (especially its artists). It helps that they have powers that make them the center of attention.
Vampire: The Requiem features the Daeva, spiritual heirs to the Toreador who are often called "Succubi" by other vampires for obvious reasons. They carry on the tradition of powers that can make everyone in the room fall in love with them, and the new weakness of having to indulge their Vices at every opportunity or take a hit to their will (most often Lust or Gluttony, but a Daeva with Wrath as their Vice is...something to run away from).
The Daeva may be actual sex gods. Their splat has stories of them being descended from Inanna/Ishtar, a sex goddess of conflict, so, at the very least, they're children of a sex goddess.
The third-party Dungeons & Dragons sourcebook The Book of Erotic Fantasy has a section on inter-creature-type sex, with a passage on a wizard who, over the course of his relationship with the vampire Duskgleam, discovered that having sex with a vampire is like having sex with "ice covered in thick velvet".
The Lahmia bloodline of vampires in Warhammer consists entirely of gorgeous Femme Fatales. This stands them in marked contrast to the Necrarch and Strigoi bloodlines, who appear to be withered corpses and feral corpse-men, respectively. The Von Carstein and Blood Dragon lineages can go either way.
It would be more accurate to say that the Blood Dragons go either way, as while the Von Carsteins don't quite have the same reputation as the Lahmians, they are still intensely charismatic aristocrats and more or less unanimously attractive. While the Blood Dragons still consist of a high proportion of aristocrats, and some of them act like they're in a courtly romance novel, the majority live in the woods or other out of the way places, training constantly and murdering anyone that they think might give a good fight, which is hardly conducive to attracting women.
They are typically described in the novels as much more attractive than their miniatures, all of whom have their Game Face on.
The vampires of the Innistrad block in Magic: The Gathering play this straight. It helps that, rather than being true undead, Innistrad vampires are ageless immortals who happen to share some vampiric traits like bloodthirst and aversion to sunlight. This fools some humans, who eagerly wish to become vampires themselves. Vampires outside of Innistrad avert this, being undead abominations and looking the part.
Interestingly, even human incantations of either Dracula or Alucard share the same aspects. The few instances we see of Dracula as human or reincarnated as human doesn't seem to lack in sex appeal, and even Alucard as Genya had the description of being "very cold but inhumanly attractive".
And Soma, the latest incarnation of the Dark Lord, is pretty easy on the eyes too...
Even the previous mortal incarnation of Dracula, the supposed Mathias Conquist was pretty bishonen by most standards.
In The Tomb of Sammun-Mak, Nefertiti the mole girl finds Jurgen irresistible. Admittedly, even before he becomes a vampire, but even moreso after that. Jurgen lampshades this.
A variation in The Witcher. For the most part, vampires are generic monsters to kill, but there's one particularly intelligent vampire who is the madam of a high-class brothel. (And, like so many other women in the game, Geralt can sleep with her.)
The Elder Scrolls franchise generaly averts this, with vampires being monsters to be slain. However, in Skyrim expansion Dawnguard, there is now a race of "pureblood" vampires. They look much less ugly, and women wear seductive robes with cleveage (which is quite unusual in the setting) and especially Serana is HOT. Not to mention leather gloves with silver claws...
An in-universe example in Homestuck; Kanaya's introduction mentions that she likes reading romance novels about 'rainbow drinkers' (the troll equivalent of vampires). She eventually turns into one, cheating death and becoming even more badass in the process. Her dancestor, Porrim, is much the same way.
Vriska also believes this; before Kanaya became a rainbow drinker, her relationship with Kanaya was platonic and slightly antagonistic. Afterwards, though, she got a crush on her.
This is one of the most popular subjects in the Nonhuman section of Literotica, rivaled only by werewolves.