Well, he said he was on a novice mage, so he likely doesn't have the magicka pool yet to spam Vampiric Drain in VL form. The damage it does is based on your Level as well, and having Serana with you removes the Damage Health portion of it, completely killing it's damage if you don't have a mod that fixes that bug. Although, at Lvl 50+ the VL Vampiric Drain spell does 25 Absorb Health+150 Damage Health, so 175 damage total, only subject to mitigation from Magic Resist itself, which very few things have. With the Bloodstone Chalice ability, "Blood of the Ancients", you can also absorb Stamina and Magicka from your target as well, making you able to cast Vampiric Drain more often because it leeches some Magicka back.