He so underdelivered recently that I began to doubt how much did he actually contribute to Theme Park, Theme Hospital, and Dungeon Keeper.
You have no idea....
Look at his back catalogue, from Bullfrog and Lionhead.
Syndicate, Dungeon Keeper, Magic Carpet, Populus, Black and White, The Movies, Fable...
I wouldn't call that a list of 'bad' games.
Let's be honest, he couldn't possibly have worked on every Bullfrog games. They released like 2-3 titles each year form 94 to 97. At some point there was probably 5 or 6 titles in production at the same time.
I know he didn't even touch Theme Hospital (he's barely credited as "Moral Support") and I doubt he was really involded in more than 1 or 2 games for this period.
He was supposed to be "Executive Designer" on the Movies, wathever that means, but again, I doubt is involvment in the production was real. At the same time, Lionhead was working on Black & White 2, were he was Lead Designer. 2 Games + running a AAA studio + his family, while having time to promise you the impossible, sorry but no.
There was a lot of talent at Bullfrog, but many of those guys went on to form Lionhead with Molyneux.
Some of them founded Mucky Foot, then came to Lionhead. Lionhead management is probably the old Bullfrog management today.
Wathever Molyneux had, he lost it. And it was probably more the ability to put together great teams than being a genious of game design. (and tbh, that could be even more impressive, considering what Bullfrog managed to produced in 3-4 years)