Also standard works on this are:
Robert D. Austin, Measuring and Managing Performance in Organizations (1996). This book coined the term "measurement dysfunction" to describe how reward structures work against company goals.
And Alfie Kohn's 1993 article in Harvard Business Review where he summarizes decades of motivational research (also citing Herzberg), concluding that giving bonuses to staff is usually a bad idea, and it is an especially bad idea for jobs that require cognitive sophistication.
https://hbr.org/1993/09/why-incentive-plans-cannot-work