It's probably a lop sided u-shape. Most people lacking in self-awareness are either really smart or true outcasts, with 'high conscientious + good communicators' occupying most middle management ... but it does take a kind of hubris sometimes to overlook one's faults, even worse, to completely ignore them otherwise. Without being controversial I see hints of this in Jobs, Ellison, Trump, Musk, Page, Zuck etc. (again I'm not condemning here, if any one of us put our thoughts online consistently there'd be a few we would seriously regret).