This is called “hyperfocus” or “ADHD hyperfocus” - look it up and you will find many, many sources. (The ADHD_love channel talks about that too.)
I would say it is a big part of the solution. ADHD brains and people can do things non-ADHD brains cannot. Is it easy? No. But it is a fact, and it is a state of mind that we can use to thrive and live rich lives. I wrote about that here:
(It is also helpful for your parenting. One or more of your kids very likely has ADHD, just like you. It is helpful to help them see their unique capabilities as they grow into their teen and adult years. They will learn to see it with understanding instead of shame.)