I never really played the campaigns but as far as multiplayer all sequels/expansions after RoR were crap. AoK was OK but still a big let down.
And multiplayer was really where the fun was for many of us. This was pretty early in the multiplayer era, so being able to play with up to 8 players in the same game over the internet seemed amazing.