Perhaps look into the symptoms of ADHD? I had this same issue for a long time, swinging between being hyperfocused and then not being able to stand the task or project for a second longer. Turns out I have ADHD and just never got diagnosed. Now, I have a name for why I swing between these two extremes.
The common clay of the new west