Your take reflects my lived experience (anecdotal as it is). I'm medicated for my ADHD and it doesn't neutralise my symptoms at all, it just mitigates some and pushes me in other areas so I can work around or capitalise on my quirks. Since being medicated I would describe myself as high functioning and my career trajectory has rocketed.

I can often trick myself to force interest in a task so I hyperfocus on that and produce great work. If I'm faced with a bunch of tedious busy work (my bane) I then spend most of my brainpower thinking about how to streamline the process. Workplace loves that stuff, and I love removing unnecessary work from my to do list. Some of the more complex work I've done has been thorough and detailed just because I was personally intrigued by the situation and wanted to deep dive for my own curiosity.

A lot of the thought processes behind the last paragraph have caused massive issues for me in the past. Hyperfocus on the wrong thing, removing unnecessary work by just not doing it, not trying to be interested and then blowing it off etc. The root causes are the same symptoms I've always had, I've just learnt to reroute them in to productivity.