I have only once worked under a manager who could actually do my job and it had plusses and minuses. I wouldn't say it was a better or worse experience than be

I have only once worked under a manager who could actually do my job and it had plusses and minuses. I wouldn't say it was a better or worse experience than being under a non-technical manager who exhibited all the traits you mentioned. The problem however is that no one I have ever worked under embodied all of those traits.