Auto-translated
The best magic is earth magic because:
1. Resurrection
2. Explosion
3. Portal to the city
4. Death rattle (if playing as Necropolis)
But I think all magic types are good, and the best magic system is in Heroes 4.
Magnus