FX-8350, 4 ghz, 8 core sounds like the business
http://www.engadget.com/2012/10/23/amd-fx-processor-refresh/
http://www.anandtech.com/show/6396/the-vishera-review-amd-fx8350-fx8320-fx6300-and-fx4300-tested
But really, I have no idea.
They do seem to compare pretty badly with Intel's (mid-range) offerings in gaming performance though:http://www.anandtech.com/show/6396/the-vishera-review-amd-fx8350-fx8320-fx6300-and-fx4300-tested/5
Though, with the heavy multi-threading you see in console titles that should be less of an issue.
What's also interesting is how the PS3 will compare, since IIRC apparently it has a quad core APU + discrete GPU. So maybe we could see the opposite of this gen where the Xbox has more CPU processing power and the Playstation more GPU power.
Piledriver is very hot+power hungry. I'd think it unlikely.
They are typically 125 watt TDP chips. By themselves. The console will probably need to be ~200 watts altogether.
I think it would be overkill for a console.