I think introverts are best leaders only in certain leadership roles. Leadership roles that require technical and deep thinking seem to better fit introverts. While leadership roles that are more people facing are better suited for extroverts.

Bill Gates's introvertness and leadership of driving the technical direction of Microsoft, while Steve Ballmer's extrovertness of being the sales guy.