So, I've worked with all flavours of these managers listed, yet none of them are the most frustrating manager I've worked for.
The most frustrating manager was the guy who read all the books, always knew what to say, tried to be your friend, but never actually let you do the things you wanted to get done. He'd never say no, but make you resubmit your requests 10 times with various tweaks almost like he wanted you to give up.
Then in staff meeting's he'd complain that no one was being innovative except his favourites who can do no wrong.
He'd give you just enough information to do the thing he asked, then give you a bit more information with an enhancement request. If I had that information up front I could have done it all at once instead of two cycles taking twice as long.
He was also vindictive, if you didn't tow his view of the company line, you were basically shit listed and he would do everything he could to transfer or fire you.
I did not enjoy that work, and I left the company because of it.