Personally I find most are fairly good, even the ones which are over the top in unrealistic, with those, they become comedy. (I see many so called horror films as comedy, it's just how I'm programmed)
The 1931 Bela Lugosi Dracula is still a favorite of mine, and works well with his 1940's The Return of The Vampire.
For an all out unbelievable comedy, I appreciate Innocent Blood, set in Pittsburgh with veteran actor Robert Loggia turning vampire. It was comical, but also has a few moments of surprise and suspense.
And for non stop hysterical laughter I stick with the rather twisted Jesus Christ Vampire Hunter...it's best not to drink liquids or eat food during the show due to laughing so hard.
Films I have never seen in vampire world are any of the Anne Rice conversions. I enjoyed her vampire novels, but when casting was done on the films the people selected did not fit with either my image of them or in many cases the way the character had been described in the books.
I've also avoided the entire Wesley Snipes :Blade: series.
This isn't to dismiss your preference to zombies, I just don't find them nearly as captivating or exciting. For me the thrill of a vampire is that they can blend in so easily with the crowd, zombies tend not to do that quite as well. Vampires although they will squabble among each other, are also quite familial in nature, zombies seem to more likely be chaotic rovers just searching for a brain, they travel in packs but I sense they're mostly loners.
I guess I just don't get zombies (although I did like the song and video from The Hooters...well, mainly the song)