@nprofile1q... I know that. I managed to fix this for my writing by turning all my writing projects into one big project, and I'm only am allowed to continue working on smaller projects if I made progress on larger projects.
But nowadays I mostly work motivation driven again. If I'm not motivated, I can't decide. But if there's a specific reason to work on a specific project, like somebody is waiting for progress, or I have a plan, or it's needed by multiple other projects