Do not listen to all this Fallout 3 is better than life nonesense. Fallout 2 would smash the 3rd ones face in.
Therefore I can redeem you from your request for a console recommendation by again proving that PC is better than life.
RPG: Fallout / Fallout 2 / Fallout Tactics (on reflection that was pretty meh...)
RTS: Command and Conquer / Command and Conquer Tiberium Sun etc etc etc (I.E The old ones, because anything past C&C Generals disgusts me)
Dawn of War: Dark Crusade... Soulstorm was pathetic.
Dawn of War II - A lot of people find it annoying to play, because as apposed to the normal RTS "Build 500000 mammoth tanks to win" it's heavily focussed on limited units in the field (multiplayer is still unbalanced to balls aswell, with Marines and Nids still dominating, 4 major patches in)
Warcraft 3 - Nuff said
Now... this I refuse to call and RTS, because it isn't as such... But it's RPG'y / RTS'y so it's hard to define, but I'd look into it:
Demigod.
That is truly better than life if you can actually find people to play it online with. As a single player game it's completely meh, but the multiplayer battles can last a fewking long time.
It had a big problem with piracy, it's makers commented that about 80% (I think it was 80%, google it to find out) of its playerbase was pirates. (Dirty dirty pirates) But there's more people with retail copies now so you may be able to find some decent games.
Don't stoop the console level! They'll make you pay for download content! (When the hell did patches become DLC's by the way? I put it down to microsoft being greedy little bummers.)