I doubt VCs have different distribution of personal character from other professional groups.
In my experience, a more interesting friction is that VCs are pursuing a diversification strategy while founders are pursing a singleton strategy.
VCs are the shotgun cartridge and startups are the shot.
It used to be that VCs wanted founders to pursue a singleton strategy, because they wanted the diversification to occur at the level of their portfolio - on the grounds that at the level of an individual startup, diversification would less likely to succeed. The catchphrase was that they wanted "pure play" investments. So it would be interesting to know why it's now a cause of friction. (The "pure play" thing was actually from before YC took off and gave founders a bit more agency; and before the "pivot" was popularised; I get the impression that VCs back then were not too happy for a founder to change direction and confuse their portfolio)