In most mythology all kinds of revenants, including vampires, were feared. There might be exceptions, but they were rare. Certainly, vampires were not seen as sexy beings until recently due to - as you mentioned - modern western media, in most cultures, they were described as looking clearly dead and sometimes even rotting. True, they don't all drink blood, some absorb your life force (like the chinese Jiangshi) or eat your flesh (as in some legends from my home country Germany), but in most tales, they are not seen as anything than a terror.
You are referring to mythological vampires, while Astarion is clearly meant to be a literary fiction vampire like any other D&D vampire.
