I used to play this game relentlessly in the early-mid 2000s. I had this game installed on my machine when it came out on steam and I picked it up and logged a few hours in (I had recently played probably around 50 hours or so not on steam).
Pros in General: Great graphics for the time (the magic effects are particularly satisfying). Fantastic gameplay. Hillarious voice acting.
Pros for Oldies: If you remember this game, get it. It's just as good as you remember it honestly. The gameplay is fantastically deep and rewarding still. The ability to mix and match front line units with support units remains as engaging as ever. You will be barrelled over laughing at the quality of the voice acting. It's so horrible that I can't consider a Con, it's just SO bad it's good! Seriously you'll love it. If you remember this game get it. And if you like games from this time period for their difficulty but sense of reward, get it.
Pros for Newbies: If you're a fan of strategy games and you're looking for something TOTALLY different to what you've played before then get this. It's very difficult to truly describe the game but here's a shot. You have the ability to form a line of main troops (spearmen, archers, swordsmen, etc) and then give them a captain and two support units (cleric, mage, sorccerer, more spearmen, etc) and it's this combination that makes this game interesting. Finding the right faction and combination of units for you is a real treat as you will find new and exciting combinations and playstyles constantly for different situations. Each of the different factions plays very differently even though some seem to differ superficially with some skin changes and a few number differences with a unit change or two they are actually significant. If you're unfamiliar with games from this time period they're a lot more unforgiving than they are nowadays but not in a cruel way. More in a way that makes you realise you made a tactical error and the enemy beat you fair and square.
Cons in General: It's a difficult game at first. Since some of the factions are essentially reskins with a few stat and unit changes, the battles can look pretty boring at times.
tl;dr: Get it if you remember it or not. Great graphics, fun voice acting, a bit difficult, but will have you feeling rewarded and like a hero of the land in no time.