I'm somewhat at a loss to think of a single "great" game of the last ten years or so that could really be said to have been spearheaded by a single person. "Civilization" comes the closest, but while every new iteration is more beautiful and refined, it's still the same game that was released in 1991 at a certain fundamental level. Many games bear the trademarks of a particular designer or designers, but few can be said to be "so-and-so's game" from whole cloth.
To be clear, I know that nearly every game that comes out now is the product of a large team. But the number of people who are recognizably thought of as personally responsible for bringing particular games into being remains fairly short: your Warren Spectors, Will Wrights, Sid Meiers, Peter Molyneuxs, American McGees.
Most of the games of the last decade that I think of as "great" are more likely to come from notable teams or companies that particular people. Blizzard, Valve, Looking Glass/Irrational Games, DICE, etc.
Still, far be it from me to dampen Molyneux's ambitions. I think he's at least as likely to pull it off from sheer effort alone as anyone else.