In my case, I was hyper-focused on computers since I was a child, and that got me my career/business and that probably saved my life -- because I was totally unable to do anything in school and wasn't able to finish first year of high school and dropped out of it. I wouldn't call it an advantage even though it's probably the reason why I'm so good with computers.
In many cases like the CEOs you speak of, you see the surface - their success - but you ignore the problems they have in day-to-day life, the ruined childhood and the ruined relationships in adulthood. Many would trade all their success for normal life.
It's definitely a disorder. A weird one that might give you above average abilities in some very specific cases and areas of life, but still a disorder. You wouldn't say autism isn't a disorder just because there are few autistic savants.
Also consider - ADHD is much more often present in highly intelligent people. What you see might be a person that was able to overcome their disorder through their intelligence, but their life would be much better and they'd be way more successful had they not have the disorder. And now imagine how a person of average intelligence with ADHD must struggle with their life.
I have an IQ of 136, which is considered to be very gifted, but my performance and life success thus far are decidedly average. It's a debilitating condition if it's not detected in time and not managed.
With regards to the second half of your post: I understand how you meant for it to come across and that you posted it with the best of intentions, but it still hurts a little bit to read. To save you the sob story, let's just say it's a bit similar to telling paraplegic to be happy with his cool motorised wheelchair that he gets to ride around in all day, and that some of the greatest achievements in history were made by people who often sat in chairs also :)
It’s a cruel paradox. A constant background of quiet anxiety, permanent absence of satisfaction, risk taking behavior combined with gripping fear of failure, and a perpetual quest for more can be a great adaptation in an unstable and insecure environment. However, it’s not exactly a blessing.
At first i wanted to disagree, then i realized why. Disorder means wrongly ordered or sickness. ADHD is classified as such, and if you want treatment, you need to get yourself diagnosed.
I really dislike the pathologizing of every neurotype that deviates from the imaginary normal person. I'm pretty sure, if you look closely you'll find something "broken" in everybody.
Other perspectives are possible. ADHD can be an advantage. A survey in a network of CEOs found over 60% have it: https://www.youtube.com/watch?v=XdT4DIiX7Nk
Some become a Rockstar: https://www.youtube.com/shorts/ElaL9Zo_Oes