Are there any Mods that add the Drain Health, Drain Stamina, and Drain Magicka spells from Oblivion, and Morrowind? I'll settle for just Drain Health.

I feel its ridiculous that Vampires are the only one to learn Drain Health when it was a normal destruction move for so long.

Assuming you mean Absorb and not Drain, it was a Mysticism spell, actually. No more mysticism school in Skyrim.

The Drain effect used to be a temporary debuff.