Vampirism worked in Skyrim, don’t see how it would work in a BG game where it is more story driven.
While I'm no big vampire fan myself neither, they do have their place in DnD RPG's - with day and night mechanism in place that is - or did you forget about Bodhi in BG2 ?