I think about it like packet loss, but for intent. With healthy executive function, one's goals and intents are persistent streams that can be held on to like a train track. (This is based on other people's description of how their mind works – I would consider that ability a superpower). With ADHD, the tracks will just fall out like a trapdoor every so often – sometimes every few seconds. You have to reinitiate the connection, but because the thing that failed is the same thing that remembers what to connect to, I have to reestablish what I want to do in the first place, and it's usually not the thing I was doing before. So I end up shooting around in semi-productive bursts, unable to see things to completion.
The other counterintuitive thing is hyperfocus – people with ADHD periodically experience the inverse. I spent nearly every waking moment in the last 3 days working intently on a software project I'm interested in. Short bouts of intense concentration (especially if you don't feel in control of their application) do not mean you don't have ADHD. They could mean the opposite.
Here's the best explanation I've ever seen of the subject: https://www.youtube.com/watch?v=SCAGc-rkIfo
Haven't found a ton of research to back this headcannon yet but there's evidence that the D1/D2 ratio is extremely important.
Also, reading your first two paragraphs makes me wonder, again, about whether I might have ADHD, especially without the hyperactive part.