You're not really arguing whether the Steam controller is bad -- you're simply saying any gamepad would be bad for Starcraft/RTS.
This is likely never going to change -- unless an RTS is designed from the early stages of development to be usable on gamepads, no gamepad will ever be acceptable for a game like Starcraft that requires 40+ actions per minute at the very lowest levels of play and 300-500 actions per minute by the professional level players. I doubt that there will ever be any controller better suited for a high-micro RTS than the keyboard/mouse combo (except perhaps some kind of direct brain-signals-to-game-input method in the not so near future ).
The only games that are even harder are very fast RTS like Star Craft 2.
I cant imagen that it will work well, but Im open to beeing suprised.