I know that adding a 'don't use spells option' or 'only use up to X mana' feature has been requested repeatedly for auto resolving fights, but there appears to be a bug occuring with mana calculations right now.
While running around late game with my hero stack of doom, bored of fighting weak armies, I was using auto-resolved, amazed at how it could use up 100 mana in a fight with such weak enemies.
Out of curiosity, I checked the details after one such fight and noticed that my heroes had only cast a few spells - on top of that, several of the spells were cast by my mage hero, who pays 1-2 mana for any spell she casts.
I then wrote down the sequence of spells, manually entered another battle and added up the totals - sure enough, they didn't match up.
It appears that auto-resolve is currently ignoring skill/item modifiers to mana costs, which is a contributing factor to the insane mana consumption occuring right now.
So: Primary fix, give us an option to control if/how much spells are used in auto-resolve, and secondary fix, make sure spells are using appropraite hero/item mods if they are turned on 