Just two corrections on some replies:
- Halo Wars is not the only good RTS game on consoles (Pikmin 1+2 and Swords & Soldiers are just 3 other examples).
- Civilization was never an RTS game on any platform and I bet my Sid Meier shrine it never will be.
RTS games on consoles are best if they are developed for the console. Two of the few exceptions to this rule (which I just invented) seem to be Tom Clancy's Endwar and the two Overlord games, which got decent ratings.
There are some good to great RTS games on PSN (I haven't played them, but ratings are good; I think they are all tower defense games except Mushroom Wars? Not sure):
http://www.vgchartz.com/games/game.php?id=33248®ion=All
http://www.vgchartz.com/games/game.php?id=26015®ion=All
http://www.vgchartz.com/games/game.php?id=39520®ion=All
http://www.vgchartz.com/games/game.php?id=35027®ion=All