Well, it’s clearly not “exclusively”. I like werewolves, elves and dwarfs, zombies (especially the quick moving kind), various shape-shifter legends, hobbits, wizards, ghosts, superheroes, psychics, mind-readers, .... You get the idea. And all of these are available in books and movies.
I like a good story with some sort of quickly established rules for how the magic in the story works. The vampire legends are pretty well established. Each story world (Stoker, Buffy/Angel, Twilight, Rice, TruBlood, Blood Ties, etc.) has a slightly different take on what will and won’t work to ward them off or kill them, but whatever the storyteller decides to use can be established quickly. It seems like cheating if they suddenly come up with a rule-breaker too often.
I think more to the point is what story the author is trying to tell. A good story isn’t just about the vampire. It’s about a struggle between good and evil, growing up, facing “your demons”, young love, forbidden love, coming into your own, friendship, family, ambition, etc.
Not every story with a vampire in it works. In a good story that has a vampire in it, the vampire is a vehicle to tell a story about emotions. Emotions are messy and magical and often misunderstood, so stories about emotions can work very well in a magical, otherworldly, secret, or metaphorical setting.
That’s my take anyway. Cheers!