When I mentor people that is usually my advice, suck it up, do it and be done. And stop spending mental energy complaining or building it up to be something more then need be.
I am not criticizing you or anyone, we all have these tasks, just sharing my own thoughts/methods on how I deal with it.
To give a little insight of what is demotivating me, it is not the tasks that are big, instead it is the tasks that are just small and not mentally challenging. Simple but frequent and time consuming. It bothers me in a sense that whenever I work on these I just feel like a car where the gearbox is on a Neutral Mode. Not going further even though the engine is running.
Give yourself a reward for doing them?
Gamify them? (Compete with yourself for how quickly you can complete them, for instance.)
Every single time it seems less and less likely the latter happens. I look through hiring threads and maybe dream that, at a different place, I would enjoy building out features.
Why ? Because it is simple and time consuming. How do I make it attractive ? Only if I can finish them without consuming time. How do I save time ? Automating, orienting to the result, batch manage them to feel like a challenge. What is the problem then ? When automating doesn’t work, when results don’t appear, when managing bulk tasks(multitasking) ends up being mentally tiresome instead of challenging, I get frustrated because they are way too simple tasks and I can’t deliver. To simplify it; Imagine when you can’t remember the name of a person but remember every other details of his characteristics, it gets only more frustrating