What I have is the opposite. In seconds I can think of this grandiose accomplishment in all its beauty if it was finished, and then I'm confronted with a white slate and tedium of doing even first steps in that direction.
What discourages me from smaller tasks is impossibility of failure. Why do a barely challenging exercise if i'm not the first to do it and not the best at that?
Exactly! My motivation primarily stems from the self-esteem boost I get from doing meaningful work that’s exclusive to me. But to do the experiments and research required to get to the exclusive domain I need to pass through the tedium of mundane jobs to pay the bills, learn the technology etc. I can find the motivation to do the tedium for minutes, but not for hours like others seem to be able to.
A result of all this is that now after 5 years of being web developer I'm already bored of the job because the small mundane tasks outnumber the challenging projects by a lot. Already switched of employer twice... Looking to do freelance work now hoping the constant switching helps keeping my motivation up.
Even things done a million times can be turned on their head.
That's why it's nearly impossible for me to make a project in modern javascript or anything like it with a ton of setup, but give me golang and it lets me just start hacking at the "awesome steps" and suddenly I'm building stuff.
I only got with it when I've learned some raw WinAPI with message breakers and stuff, but all and all fitting a program in one source file.