I agree with the above sentiments: (1) RTSs are too hard for most peoples liking, and (2) the genre doesn't convert well to consoles. So it's a niche PC market. And yeah, if Battle for Middle Earth 2 is one of the more active RTSs still around, that make one wonder if its best days are behind us.
RTSs the last couple years have been faced with tribulations and glorious failures:
1. The best RTS maker, Blizzard, has devoted itself to, ahem, an MMO you may have heard of.
2. Dawn of War was popular but poorly supported with some terrible patches and mediocre expansions while Relic poured it's heart and soul into Company of Heroes, which hardly anyone has heard of.
3. Supreme Commander never really got rolling, probably due to heavy computer requirements making it even more of a niche market than strategy games already are.
4. Universe at War, well idk, I thought it was better than its sales data suggests, and it had an unusually good control scheme, but then again, I stopped the single player campaign in disgust after they [SPOILER!!] killed Orlock [/SPOILER]... and the community was never there.
5. Now, World in Conflict has the greatest RTS engine imaginable; I wish every RTS were ported to the World in Conflict engine... but the gameplay was bland and un-strategic and the story was the kind that thought it should get an Oscar but it was really stupid, so World in Conflict barely scored a blip on the computer gaming scene. I really hope they make more games with that engine, though, or someone licenses it.
6. Sins of a Solar Empire was very fun and was reviewed well and sold well, and had a number of successful innovations, however it failed to develop the story behind its universe, and games take unbearably long so I had to put it down.
7. So the battlegrounds in World of Warcraft have been the most RTS fun I've had in awhile. Unfortunately, your units you cannot just click around, but have to "convince" to act in a coordinated and half intelligent way through battleground chat, and then they start to talk back and call you names if you get too bossy. =p Plus there is that unbearable grinding to get to the fun parts. Ugh!
So, life has been hard for RTSers of late, compared to the cornucopia of shooters and role playing games which have come our way. **BUT** 2009 offers a lot of hope. Starcraft 2 is shaping up to be the best RTS ever, and hopefully will bring people back. Dawn of War 2 may be a contender if Relic keeps what made Dawn of War so fun, and brings in what it learned from Company of Heroes (AND makes the UI more modifiable which was the deal breaker for me and CoH). Red Alert 3 is very much showing the age of the Command and Conquer series but is a likable romp. Having played the beta I'm figuring Battleforge is going to be another glorious failure but time will tell... it's interesting and might catch on.
So anyway 2009 is shaping up to be a very hopeful year for the RTS. This is not the time to be pessimistic about the state of the RTS genre.