Yeah...you know Brad Pitt and Tom Cruise did it best in Interview and the Twidorks have nothing on them.

There are like six great vampire films in history and none of them (in my opinion) are in the Twilight Saga (I vurp a little bit each time I'm forced to write that).

Anne Rice's Vampires? Tres sexy. Bram Stoker's Dracula? Wicked and just fucking hot. The rest get a big thumbs down from me.

I found Interview with a Vampire to be so long and boring, though Pitt was definitely sexy.

I went into Interview thinking I'd be ok with Pitt, and detest Cruise. Instead, I really hoped someone would stake Louis (Pitt) — who was too damn emo, even for a vampire — and Lestat (Cruise) surprised the hell out of me, in a good way.

ETA: @ the OP
I'm not tired of vampires. I am tired of POORLY WRITTEN vampires. There's a difference.

never was into it at all

I can see the attraction, but I feel largely neutral about them. "Oh, vampires. Is it an original story or a fanfic based on World of Darkness?"

I'm sick of them too

It depends. I like mine with to have a bite, so to speak, so I hate the "sparkly, pretty" vampires, but the ones that have that...bad side draw me.

Interview with the Vampire was actually the first movie that I saw Tom Cruise in that I went, whoa, he IS a cutie . Might have been because we got to see him all scruffy and in a ponytail at StarCon lol.

I like vampires as long as they're well-written and actually have some depth and darkness to them. I like them to be something you should be afraid of, and I like them to have some strong connection to actual vampire lore.

Some, I agree with, though my heart still beats faster when I watch old episodes of Buffy and Spike comes on the screen

Nope, still like them, and I think I always will.

I love vampires, but I love them done right.

Though what does a girl gotta do to get some hot Werewolves in stories that become insanely popular.

Tired of vampires? No.
Tired of vampires as romantic/sexual interest? YES.

Yes, there is a very sexual aspect to the vampire as we know from various eastern European folk traditions, but that's a big part of what makes them *horrifying* not romantic.

Vampires feed on humans and livestock, either killing them outright or draining their lives slowly, so a vampire story can horrify with an "destructive relationship" or "Am I in love with a murderer?" angle.
Vampires rise from their graves to revisit their family, especially their spouses and loves, so a vampire story can horrify with a character being pursued sexually by a corpse.
Vampires (and this is part of a lot of folk traditions that gets skipped in fiction, surprisingly) can even leave their village of origin and start a new life elsewhere, include a new spouse and children, so a vampire story can horrify with a "killer in our midst" or "How well do I know someone close to me?" angle.

Of these ways of using the vampire in fiction, only the first one really seems to ever get used, with the "murderer" aspect downgraded to a less threatening "bad boy" or "tragically misunderstood" trope. It's a waste of a really good archetype, as there are other ways to set up an anti-hero as romantic interest. If in a book there's a reanimated corpse who's primary thought is LITERALLY suck the life from the protagonist and you *aren't* at least a *bit* scared, somebody's not writing very well.