Same here! When that spark of interest hits, I program complete prototypes within days. When it doesn't, I sit around for dozens of hours just staring at an SQL migration because I'm trying to write a Subselect and the things I want to select keep slipping out of my mind before I can write them down.
What has really helped recently is that my Product Owner gave me free reign of the entire Scrum backlog instead of confining me to the tickets that were planned for the next two weeks. So I can just scroll around until I see something that sparks inspiration and do that instead. Makes it very unpredictable when things get done, but on average, I'm faster on the tickets that I do than anyone else would be.

[–] boonhet@sopuli.xyz 2 points 3 days ago

My current form of work is the opposite and it sucks. I get given 2-3 tasks at a time and that's it.

I need to get into a product based company again.