I don't think you can build tesla and spacex without being a no-man in certain fields. It's just that Elon got bored, and he entered a new realm of a social network product, not an engineering product, and he's finding out quickly how different that is.
At the same time, I do think Elon's asperger type genius is definitely more suited to engineering startups, and Job's super sensitive artist level narcissism is more suited to UX intensive startups. Elon ventured where he shouldn't have.
Being a yes-man doesn't make you categorically stupid, but a no-man is strictly further along in some of the dimensions of intellect and creativity.