I would rather work for someone honest than for a bullshit artist. But I wouldn't necessarily decline to work for the world's best bullshit artist. Just that you want to be very sure you know who at the table is the sucker.
Ideally you get someone whose good at both, or at least competent at one and really good in the other, such as Jobs or Gates.
Look at DEC, a classic engineering company failure. DEC failed because they were led by engineers who didn't understand the market. It apparently was a great place to work, because they were so NIH that they built everything from scratch.
Then look at Intel, a company that is in the process of failing because they listened to their customers too much. None of their customers wanted GPUs, or mobile chips, or power savings - until they did. By that time Intel was already behind the curve.
Then look at Microsoft under Ballmer - a company that probably illustrates the point you're trying to make. But then they won with Nadella, luckily.
Apple is a bit different and a bad example because unlike other companies they attempt to define the future. Most companies aren't in a position to try, much less succeed, at this.