In my case it's weird (i have "minor" adhd). Nothing is consistent.

One thing can help is getting rid of distractions out of sight. Another thing that helps me is being organized. Keeping stuff in phases as much as possible keeps me from going depressed.

Despite all that... I need to work on my infra but working on my debugger has been nicer... bleh. Dunno about motivation. I have that fear of failure.