The eternal question: which heroes are better, mages or warriors?

If I'm going to war, I can take Wisdom and Water Magic (Blessing, Prayer, Clone) or Fire Magic (Berserk, Armageddon, Blindness).
These spells will be more useful!