Women went ga ga over Brad Pitt playing Louie, and men go ga ga over Kate. Women thought stewart townsend (iirc) was sexy as hell in Queen of the Damned. Brad Rocked, Townsend was everything that I thought Lestat should be (which happens to be everything that Tom Cruise lacked playing the part), and Kate rocks in her respective role as a hunter. Vampires are supposed to be sexy, as part of the allure.
Unfortunately Twilight makes a total mockery of what a Vampire is. Think about your own psyche after 400 years. You fell in love to watch someone die, and then did it again, and then again. You've witnessed man's own atrocities toward mankind, and in the end somewhere lost your humanity. People are nothing but cattle to you. Sometimes one may come as close as a pet, but in the end, you look for and find companionship in your equals. Because you've figured out after all this time that even if you decide to give the dark gift of immortality to someone, 99 out of 100 times they will come to resent you for it, and then come to hate you simply because they can not handle true immortality. Not to mention the thought of killing their fellow man in order to survive. Most people on earth would end up walking all night out into a desert, and falling asleep while the sun rises. In order to truly be immortal, one would have to lose a sense of humanity, or lose the sanity that they cling to so precariously.
Even with all of this, we find the Vampire sexy. Could I be immortal and make it through somewhat intact? Probably not, I like to think I care too much. Trade spaghetti for blood in an attempt to live forever? Bite me here please.