Mana Drain eventually leads to Mana Clash, which is an awesome spell. In fact, if enemies would use this spell on your mages, the game would be almost impossible to play.
Spell Might is a great spell since it is necessary for Storm of the Century combo, but again you need to take 2 crap spells to gain access to it... so in the end one might as well simply take Inferno.