I think it'd be helpful if we maintained a list of controllers that can support Xinput without x360ce (thus big picture mode compatible). Make a post below if you have one to add and I'll edit it into the list.
Xbox 360 Controller
Price/hookup: $40/50 for Wired/Wireless variants.
Notes: The wireless is not bluetooth and thus requires a special adapter. Requires 2 AA batteries (and costs extra if you want to buy a rechargeable pack).
Logitech F310 Gamepad
Price/hookup: $25 for Wired
Notes: A decent controller at a good price for actual use, but the cord has a tendency to come out of the controller, breaking it. Can't recommend buying this.
Logitech F710 Gamepad
Price/hookup: $50 for Wireless w/ 2.4 GHZ USB "Nano Receiver"
Notes: The latency of the F710 is a bit less than with the wireless 360 controller, making a bit more responsible for PC gaming. It is roughly the same price though, and I think most people agree that the triggers aren't as good (it's closer to a PS3 controller).
Sony Dualshock 3
Price/hookup: $50, can be wireless or wired (charges/connects via mini USB)
Notes: Requires MotioninJoy, which is free and easy to use. Much better than x360ce and has universal compatibility with Xinput. Decent latency, but most people don't care for the convex sticks and triggers. But if you already own a PS3 and don't want to buy a new controller, this is an attractive choice.
Xbox 360 Controller
Price/hookup: $40/50 for Wired/Wireless variants.
Notes: The wireless is not bluetooth and thus requires a special adapter. Requires 2 AA batteries (and costs extra if you want to buy a rechargeable pack).
Logitech F310 Gamepad
Price/hookup: $25 for Wired
Notes: A decent controller at a good price for actual use, but the cord has a tendency to come out of the controller, breaking it. Can't recommend buying this.
Logitech F710 Gamepad
Price/hookup: $50 for Wireless w/ 2.4 GHZ USB "Nano Receiver"
Notes: The latency of the F710 is a bit less than with the wireless 360 controller, making a bit more responsible for PC gaming. It is roughly the same price though, and I think most people agree that the triggers aren't as good (it's closer to a PS3 controller).
Sony Dualshock 3
Price/hookup: $50, can be wireless or wired (charges/connects via mini USB)
Notes: Requires MotioninJoy, which is free and easy to use. Much better than x360ce and has universal compatibility with Xinput. Decent latency, but most people don't care for the convex sticks and triggers. But if you already own a PS3 and don't want to buy a new controller, this is an attractive choice.