It can feel like a super power at times. But it's one you cannot control. When I was in my teens and early twenties my area of interest happened to align with something which would turn into a very lucrative career. Software development. I couldn't get enough of it. I soaked things up like a sponge and was able to internalize so much that has stuck with me. But once I "figured out" programming, the interest dropped to almost zero. I love solving problems and learning things and there is no way in hell I could participate in
most software development teams because the vast majority of programming is little more than typing out previously solved problems. There is no mystery to a CRUD API endpoint. The only time I jump into code these days is to help out with tricky bugs. Diving into an unfamiliar code base to solve a problem others aren't able to checks all of those puzzle solving and learning boxes which gets my attention going again.
I'm not sure about building a business with ADHD. I see that path as extremely difficult unless your super focus happens to align with what your building long enough to get to a point where you can make money off of it. That seems unlikely. Once you're running a successful business, I believe coping with ADHD would be significantly easier. A CEO can delegate the things they are worst at to focus on the thing they are best at and which deliver the most value. The vast majority of individual contributors don't have that option.
ADHD keeps me on the move and has given me a very broad skill set and understanding of many different industries. I've worked in health care with medical devices to building interactive kiosks to writing device firmware to applying AI to livestock management to insurance and banking modernization. In that sense it's a super power. But I still cannot build myself a personal website or blog despite wanting to because that shit is really hard for me.
This doesn't even touch on the damage ADHD can do to relationships. I had a very difficult time connecting with my children when they were babies and toddlers because, let's be honest, they are boring most of the time. This became significantly easier as they got older and we were able to start actually having conversations. There are also times where my inattentiveness gets to the point where I literally cannot pay attention to what my wife is saying. It's a struggle to try to separate my brain from what it's trying to pay attention to and redirect it to her. When I don't see people they basically stop existing. I have no relationship with my parents or siblings and almost no long term friendships because of this. It's extremely easy for me to get disconnected.