http://www.cronusdevice.com/
Stumbled upon this magical little gadget a few months ago and its amazing. It basically allows most of the popular input devices to be used on the PC and both consoles. Its not exactly cheap but if you use multiple systems like me and prefer different control methods its a life saver.
It also has inbuilt buttom mapping set to profiles, so you can switch mapping mid game ie Ps3 controller often uses R1 L1 to fire, while Xbox 360 uses RT LT (R2 L2 equivalent). Using this you can get around games which support no remapping. I have PS button + Select mapped to cycle profiles.
The website explains it better, but it comes in two variants. The basic one and the Xtreme which supports MODs. I brought the Cronus Device regular from the rainforest named book store.
I've used motion joy for years and became increasingly frustrated with it. Its pretty unstable, needs to be online (unless moded), has an awful interface and in the past given me blue screens. Not to mention support for it has ground to a halt. I also have a hat full of usb bluetooth dongles that I brought as part of the lottery to get wireless supported (until the official one could be brought).
Beauty of the Cronus Device is it doesn't even need the official wireless xbox 360 reciever to work. All you need is to install the 360 for windows drivers, and it syncs up wireless, as a 360 pad. It also remembers the ps3 pad, so next time I turn the PC on all I do is hit the PS button and its synced again.
Was going to make a post about it when I first tested it, but never got round to it. For me its been amazing. These threads always seem to pop up so hope it benefits people wanting to game with a PS3 pad.