Total Annihilation: Kingdoms
Everyone loves the original game, but for some reason nobody talks about it's fantasy spin off, which is still pretty damn fun.
Speaking of which, I think I had my second hardest battle in the game so far. First one was Mission 34 in the base game, this screenshot is from Mission 8 of Iron Plague expansion.