The bestselling author of Team of Teams dismantles the Great Man theory of leadership, by profiling leaders whose real stories defy their legends