Brutal Legend is the best one by far, considering it's the only one I know of which doesn't try to force a PC-style top down RTS onto a controller, and instead takes the much better approach of putting you and your opponent in the position of fallible army leader rather than omnipotent god in the sky.
And the multiplayer especially is amazingly fun once you get into it. I really recommend giving it a try, as I said it's really the only kind of RTS that works well on a console.