I think of my own experience. I can focus long periods of time on something interesting that solves a problem, but when most work is simply business logic and reinventing the same uninteresting wheel at a desk for 40hrs a week, I feel like a caged animal and cannot focus whatsoever.
The behaviors associated with ADHD are quite literally anachronistic. The ability to take in a lot of stimuli and react on it would have been extremely useful during say, a hunter-gatherer time. Someone to try to figure out what those weird berries are useful for, fiddling with some sticks and ending up with a tool, etc.
We're really not meant to sit around all day being "productive".