The only RTS I've ever played that could work well on a console is Hostile Waters: Antaeus Rising, but it is an RTS/action hybrid. You can control your units with simple three stroke keyboard commands (unit key, action key, target key) from the unit you're focused on, or you can basically pause the game while you go to the map and give more complicated orders.