I don't think anyone in management turns up thinking I want to create the most toxic work environment and work only with folks who are not good at anything or need the whip. Even the best intrinsically motivated people need an environment and challenge to rise to the occasion of doing their best work. Sometimes it's peer competition, at other times it's unreasonable deadlines.
On an individual level our desires and goals are fairly mimetic. Our motivation to do work is a function of our desires, goals and the difficulty level of the problem. A bunch of the observations around theory x/theory y doesn't account for what individual motivation is and how is it derived.
A lot of this literature stems from older generational simpler classification models around how to influence human motivation. In classical Indian literature, a famous Indian philosopher Chanakya talks about Saam, Daam, Dand, Bhed to get things done. Translated it means - persuasion, price, penalty and coercion to get things done.
While philosophically we can lean in on similar models applied to management - the key here is a lot of these theoretical models need evolution to really apply to individuals and situations.