Ps3 controllers need drivers like Motion joy, then you select emulate xbox controller. From what i've read, quite a few people have issues after installing them such as BSOD etc. I used it on Sleeping dogs, didn't have too much of an issue. Took a bit of tweaking and messing around etc. It also sometimes changed my binds, but i eventually got it working ok.
An Xbox pad is definitely the way to go if you use a controller a fair bit on the pc.
@Pug: You forget that site emulates almost any console ever made. It's got games like Goldeneye for N64 which was one of the best shooters in history. Graphics might look funny compared to now, but that game is timeless.