Which level of magic do you use the most (Heroes of Might and Magic III)?

I agree with the argument that powerful combat spells lose their effectiveness as the army grows. So, in my opinion, the 5th level is only needed for the "Door" and "Fly" spells.
Otherwise, the 4th level is clearly better – resurrection, portal to the town, prayer (which no one has mentioned), and Berserk.