There is a group of folks who fit the management consultant profile, and as you say, they can add value if well policed and in the right place.
There is also a group generated by the "red queen" characteristics of corporate life. These are the folks who are optimised to appeal to seniors with polish and politics, but who have no real bottom. I've only seen a few of them rise up (and not to the very top) it's not good to be around them when the reckoning comes.... Peacocks don't do well round foxes.
As an ex management consultant I can say that I saw not only many different job types within that description, but also many degrees of competency within those roles. It's not fair to apply sweeping generalisations to any class of people, be it consultant, software engineers, designers, venture capitalists, or people of a particular race, religion, ethnicity or gender orientation.
Their characteristics are rapaciousness, self focus, political and emotional manipulation and greed. They do well for themselves, not so well for the company.
So, I question the premise of this article from the beginning as its source material is not successful CEOs who spent more than 10 years at the company in question or in the CEO role.
Edit: I see I'm being buried. To be fair, there's a difference between a "management consultant" and an consulting engineer. consulting engineers get stuff done. Management consultants can also come up with great ideas (as shown in the show I referenced above) and can legitimately add value. But they are best as consultants, not employees and not CEOs. Of course generalizations are false if applied strictly- there are exceptions.
I just think that a better survey of successful CEOs would be necessary to draw any serious conclusions.
AND - more specifically- having worked with management consultants and a variety of CEOs of startups who didn't have startup backgrounds, for a startup you generally don't want a management consultant as your founding CEO.