Command & Conquer 3 on the Xbox 360 is an excellent game and a great example of how a console RTS should work.
User Rating: 9 | Command & Conquer 3: Tiberium Wars X360
If you think it sounds over the top, you'd be right--but it's cheesy in a good way, and it won't take you long to get involved in the story and the characters that drive it. The narrative is structured well, with the Global Defense Initiative and Brotherhood of Nod campaigns telling the same story from opposing viewpoints. There's also a new player in the mix: the alien Scrin race. At this stage in the series, the mineral tiberium has propagated over most of the Earth, but it's more than just an environmental plight--it's a key to future technology. It'll take you a couple dozen hours to get through the campaigns, and just when you think you've finished, there are a few surprise missions in store, and they are well worth the time it takes to unlock them. There are also plenty of reasons to return to the campaign once you're done, since the game rewards you with medals based on your performance. The missions themselves are incredibly varied and involve a lot more than destroying an enemy base or defending a particular structure. You'll have to do these things, of course, but you have both primary and secondary objectives to complete, and they include using engineers to capture certain buildings, amassing beam cannons to take out defenses, or teaming up with your sworn enemy to defend against alien attacks. You'll be doing it all in a variety of real-world theaters, such as Washington, DC; downtown Sydney; and the eerily dry Amazon basin. The near-future take on familiar locales makes the intense battles feel even more thrilling because the settings are recognizable and meaningful. 
