It would also be nice to have a job solving interesting computer science problems, like building compilers, tools, optimisation systems, etc. But that's unlikely unless you're actually a genius, or at least an accomplished academic, but some of the things you have to do to get ahead in academia seem even more demeaning than writing CRUD apps.
Instead every single job in my career has been the mess that you describe, and I'm starting to lose hope that there is anything other than it in this industry. I think it's the absolute worst of both worlds. You're solving completely trivial problems, but you're forced to do it in the most convoluted way possible. You sit all day racking your brain under maximum cognitive load trying to accomplish something so trivial and mundane that every single fill-in-the-blanks framework already does for you out of the box.
Somehow we have an industry of people who believe that work needs to be a source of personal entertainment instead of, you know, work.
Expectations need to change. Imagine if other occupations were like this? You hire a plumber to fix a clog and they spend the entire day on fastening some custom device because they felt that using a drain snake was just too boring.
Compare to product owners and engineering managers who either have no clue how bad it is, or have been conditioned to believe that it is completely normal or even desirable.
>Somehow we have an industry of people who believe that work needs to be a source of personal entertainment instead of, you know, work.
More importantly it should be a source of money for living without either burning yourself out or causing the poor sods who have to clean up after you to burn out. The current state of affairs is hurting both employees and employers. Just telling the employees off doesn't change anything or help anyone.
There are still tedious/repetitive things that come up, though, and if the repetition is bad enough, then there are opportunities to do something clever... But again: Can it be done simply enough to make it worthwhile? Another challenge.
And sometimes you just gotta do the dirty work dirty, and hang in there. Admittedly that is part of any job done well, in the long run.
This is kinda dangerous advice, because I've been involved in countless CRUD apps where the developers were bored and made things more interesting for themselves; NoSQL databases, difficult programming languages like Scala, microservices, CQRS, infrastructure-as-code that was never used in practice (it was wishful-thinking-as-code), home-rolled frameworks (one involved the CTO / lead developer to basically work from home and stay underwater for six months before coming out with a C# framework; it was just e-commerce that used a 3rd party to do all the heavy lifting), etc.
Heed the magpie developer. Choose boring technology. Eat the shit sandwich or move on if you think CRUD is beneath you.