If is good that you have flagged this problem. My experience is that if you are in the right occupation and supported to do what you are best at, it is possible to keep going. When work becomes or includes a burden, things fall apart.
My solution is to find a practical approach. Ideally that would be one or more of: getting someone else to cover off the tedious work, getting a coach (paid or a volunteer, finding more absorbing work. It maybe you have reached the point in your career when a total review is needed, or at least to examin what aspects of your work you are emotionally attached to. If you combine what you love, what your good at and what pays, you might find you are on track to solving the problem.
If you would like to explore the above I would be happy to talk you through some ideas.
Looking through all the replies, you have certainly found an issue that affects many people, and I hope you find the right guidance.