Earlier quoted context omitted.
Oof. This is probably most people, too. There need to be more jobs where the interest alignment in work is 100%. Disney animators, Nintendo programmers, audio programming, SpaceX engineers, ML/AI, bioinformatics, ... Rockets, chemicals, machines, visual toys, solving moonshot things, ... Less plumbing and glue code. Less adtech. Less studying and optimizing trivial human interactions that nobody will remember.
FWIW, I find glue code and integration to be quite rewarding sometimes. You take other good, useful things and connect them, resulting in a new/bigger/better useful thing... without "doing anything"! :) Seriously, for some of the things you mentioned, I suspect the key is to NOT be highly focused on the career path which pays the most. I kind of doubt that audio programmers are paid as much as Sharepoint developers,…
Sometimes people call it a niche field, but I think they are typically just over focused on imagenet.