Definitely NOT Edward Cullen. My nephew loves Twilight, but I can't say I ever got into the craze over those movies.
For most emotional vampire, I'd have to say Barnabas. For scariest vampires, I have to go with the ones in the TV miniseries Salem's Lot back in 1979. Now those creatures REALLY gave me nightmares.