Ursula Franklin wrote many years ago about the tension and tradeoffs that touches on here. Most relevant is her discussion of prescriptive vs. holistic technologies. From her first lecture in her 1989 CBC Lectures The Real World of Technology.
It is the first kind of specialization, by product, that I call holistic technology, and it is important because it leaves the doer in total control of the process. The opposite is specialization by process; this I call prescriptive technology. It is based on a quite different division of labour. Here, the making or doing of something is broken down into clearly identifiable steps. Each step is carried out by a separate worker, or group of workers, who need to be familiar only with the skills of performing that one step. This is what is normally meant by “division of labour.”
This framing of prescriptive vs. holistic is very enlightening in the context of AI. In many ways, it offers opportunities to strengthen either manner of work. Understanding the relative values of each should shape the way we choose to apply AI.