Steam seems to have standardized on the XBox 360 controller. At least that's what they support with their current "couch mode" thing. So it seems like you don't need to worry too much about choosing the wrong controller since there is only one choice at the moment.

It works pretty well, for what it's worth.