In MP this spell would only be useful to get the extra magic paths. Its just too expansive for what you get, which is far too random anyway.
The one time I cast it in MP, was just experimenting, got 1 mage, 17'ish warriors. The warriors died the next turn..., the mage was useful but not worth the gems.