Command & Conquer
C&C Red Alert
Warzone 2100 (this one is free to play on PC nowadays, I strongly suggest you do)
All excellent RTS games, all on PS1. 2100 was full 3-D as well, it was fantastic.
They all used variations on mouse/cursor controls mapped to a controller. It worked fine, they even had micro management short cuts in the form of button combos.
As far as current console RTS's go, they won't work commercially. Even Halo Wars, with the marketing brand name juggernaut attached has been a modest rather than big success. It certainly didn't stop Microsoft laying off all the developers and gutting the studio.
No-one is rushing to make a Halo Wars clone, the way everyone and their dog has gone in for Halo (or Silent Bomber if we're being pedantic, which I am) style regenerating health-limited gun-voice in your head fps games.
It also hasn't erased the world's memory of innovations made before it the way Halo did, so it's not seen as new by the console gamers and it's seen as too shallow by the PC crowd.
I honestly don't think RTS games suit the consoles, or rather the console's players. RTS players tend to be older and more methodical than most console gamers. I can't see 11 year old getting obsessed with tactics.
Halo Wars was about as simplified as you could get before you started getting dumb and it still didn't hold player's attention, I can't see anyone else doing any better.