To expect most, or even many, jobs to be motivating or inspiring or even enjoyable is unrealistic. And to be fair, many people would love it if the worst thing about their job was that it was merely tedious. But in any case, the work exists and has to be done.
Automation might provide an escape from some bad jobs, but the purpose of automation is to allow companies to extract profits from labor without compensation, not to free people up to improve their lives. People will likely simply go unemployed in that case, or be forced to find work in the diminishing labor market that remains.
UBI might also help by decoupling the need to survive from the desire to work, but there will probably be some intersection of jobs that are both bad and infeasible to automate, and someone will still have to do that.
