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.
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.