As with ASD and neurodivergency at large, ADHD is a spectrum, with differing impacts for differing people.
As with ASD and neurodivergency at large, ADHD is a spectrum, with differing impacts for differing people.
In the overwhelming majority of cases this scattershot approach is deeply frustrating for the individual, and orders of magnitude less productive - in terms of meaningful creation and innovation - than persevering on a focused set of tasks.
I can think of many examples of times where I was unable to complete a project (in part) due to a drive to answer every question that I encountered in the process, and questions branching from those answers. So yes it does definitely impact productivity and perseverance for specific tasks, but I would separate that from the unique ability to learn intensely about interesting topics with reasonable depth and exceptional breadth that ADHD seems to give.