You are hinting about an important third trait: persistence (effort). I am not the nicest person, nor the smartest, but I am very persistent. This can make-up for other shortfalls. When hiring, if I cannot find highly competent, then I will sacrifice some niceness for more persistence. Never hire people who are low effort / not persistent. Some much of office work is "following up" to make sure that things are completed -- non-managers included. People with low effort will frequently complete tasks to 80-90%, then need to be managed across the finish line.
Edit
About: <<needing to be told exactly what to do frequently, and eating up lots of other people's time>>
I recommend that you Google: youtube casino blueberry muffin
Watch that two minute clip. It ends with this quote: <<Like everything else in this place, if you don't do it yourself, it never gets done.>>
I often mutter "blueberry muffins" to myself when it is easier to do it myself than ask someone (multiple times) to do it, and the results will be incomplete or low quality.
Edit
About: <<needing to be told exactly what to do frequently, and eating up lots of other people's time>>
I recommend that you Google: youtube casino blueberry muffin
Watch that two minute clip. It ends with this quote: <<Like everything else in this place, if you don't do it yourself, it never gets done.>>
I often mutter "blueberry muffins" to myself when it is easier to do it myself than ask someone (multiple times) to do it, and the results will be incomplete or low quality.