I would be very interested in a data point of a successful startup headed by a non-technical founder whose principal role is to harangue and berate and exalt his tech team. Oh, and to make Excel spreadsheets
(Steve was medium-technical, back in the day, though IIRC he never designed any of Apple's hardware or wrote any of their software.)
I believe the CEO of the video game company I used to work at was basically exactly like that. He had been a producer before, and then started his own studio. Granted, his principle role was marketing, business deals, and strategy. He occasionally made comments on design decisions, but everyone knew how to work around him because he didn't know what he was talking about..