I also like the magic of Water – mass prayer is very cool! It speeds up and strengthens units significantly. Mass forgetfulness often helps. Mass blessing is a very powerful ability. And, of course, mass healing and removing enchantments are very helpful!
But, in my opinion, fire magic is weak. Berserk in an area is cool, you can sometimes use sacrifice effectively, but it can’t compete with the other schools.