It works with any game. If it doesn't have native support for the controller, all you have to do is run a program called xpadder and map the standard keyboard/mouse controls to it.
I have one, it's great for a HTPC, but terrible otherwise. A keyboard/mouse is so much more intuitive. If you get one, don't expect to be able to play online. You'll get creamed.