Certainly not the best thing since the wheel, but enjoyable nonetheless.
Also, the game has 3 different civilizations (with a fourth one in the expansion pack) which are Greek, Egyptian and Norse. They all play (slightly) differently, and they all have their own unique God Powers and Myth Units, as well as their own ways to acquire them. This is a welcome break from the near-identical civilizations you had in the Age of Empires series.
The combat, when compared to the latest addition to the Age Of series (AoE3) is a lot better. I prefer sword+bow combat rather than lines of musketeers standing still whilst shooting at each other. It just looks much cooler.
Like all RTS games, there's a single-player campaign. It is surprisingly good - I always felt that the campaigns in Age Of games lacked something. This one doesn't. It has a good story, almost all of the characters are interesting, and there are a lot of cool missions which are tied together quite well. Even the standard "build a base and destroy something" missions usually have a nice twist to them. If the campaign (titled "Fall Of The Trident") is not enough for you, you can also download a free additional campaign on the official website. It's a lot shorter (about 4 missions) but if you're a die-hard fan I suggest you give it a shot.
On to the multi-player bit - As a new player it's quite hard to find a decent room, seeing as there is a lack of a proper matchmaking system and you can't really base yourself on the ESO rating, as most players - good or bad - have a default rating of 1600. Meeting someone with a lower or higher score than that happens very rare. However this should only be a problem in standard maps. There are a few mildly enjoyable custom scenario's available on-line (you'll auto-download them as you join servers using them) but unfortunately most of these are for the The Titans expansion pack. I suggest buying the expansion if you really want more out of this game.
All in all, you should really get this game if you're a fan of RTS games. What are you waiting for? Go get it!