I had a similar experience. I absolutely would not have the career I have today if it wasn't for ADHD driven hyper-focus on things I was curious about. I was lucky enough to be interested in technology and programming. By the time I (barely) graduated high school, I'd become proficient in multiple programming languages. My first "real" job after school wasn't with technology. I was copying microfilm and filming newspapers for archival. I walked by one of the programmers who was working on the website and started asking questions and pointing out potential issues I saw. I'm fortunate that this was an open minded guy, because I don't think many software developers would react well to some know-it-all teenager pointing out issues in their code. Instead it turned into my first software development job.
This curiosity for technology and programming continued for about 10 more years. I was absorbing everything I could find from patterns and practices to other programming languages. I learned about linux by following the Gentoo guide. All of this was easy and natural for me because my brain wanted to dig into these topics. At least until it didn't anymore. At some point learning a new programming language wasn't "new". It was just patterns I'd seen before in other languages, so exploring those things became far less interesting and all but stopped. I got to the point where I could see the solution to a software problem before writing code, so the act of writing the code became extremely tedious for me to the point where I literally couldn't do it. I lost jobs over this until I was able to shift more to architecture work.
The same pattern followed there, where I was able to quickly absorb tons of content around systems designs and larger concerns for large software projects. I threw myself into it for more years because it was easy and my brain liked this content. Until it didn't. Things that were so easy for me because a huge personal effort to complete because it wasn't in that "zone" of things my brain wanted to engage with. It wasn't new and shiny. It was boring and tedious. It's a job I'm great at, that I cannot perform adequately because it's not interesting to me anymore.
So throughout my life ADHD has helped me enormously by enabling me to pick up skills that my peers didn't have because I was almost "addicted" to learning these things. But it's also a huge limit because I always have to be working on new things or things which are on fire. I love critical issues because the immediacy of the problem helps engage my brain on delivering solutions. I absolutely cannot work on "boring" projects which are well maintained and delivering effectively. In that regard, ADHD is a huge anchor holding me back. Sometimes I feel like I have super powers, but I think it's more similar to being an "idiot savant" where I'm very good at the things my brain agrees I should be doing and very bad at things I cannot focus on and I cannot control where that focus goes.
If you're lucky that your focus tends towards things which are worth money in the job market, I can see how it could be a huge help early in your career when you're still soaking in information like a sponge. I can't imagine what my life would look like if my ADHD took me down the path of anime or something like that instead. None of this touches on the social issues which arise from my ADHD. I also got very lucky to have a wife who understands and helps compensate but it still adds a lot of friction.