Mostly for 2D games (Rogue Legacy, Rayman Origins, various... games which are for other platforms...), but also for some 3D games such as Batman Arkham Asylum/City. How are the Logitech gamepads? I've heard mostly good things, but some negative reviews complain about the shoulder buttons and the joysticks.
PS3 is my choice, although I already had 3 of those controllers sitting around so I didn't have to buy anything. I might still have went with that though, since IMO it's the pinnacle of controller design (minus the non-replaceable battery.)
My movie and gaming room: http://imgur.com/a/IjWr1 My pets: http://imgur.com/a/P9VGU