All quirky fun and games until you realize you can't do high-paying jobs that requires consistent focus. Which is not really a problem unless you want a family or to live in nice parts of cities.
This is not a good understanding of ADHD. People with ADHD have hyperfocus tendencies, and this in fact can apply to their job while they ignore everything else.
That is to say extremely successful people might be that way BECAUSE of their ADHD, not in spite of it. A programmer who devotes the majority of their life to learning their craft, or an artist who spends all their attention on their next (or first) hit album.
But it's an even worse understanding of what high-paying jobs actually require.
A mathematical example would be right around the point where one finds that the delightfully focused exploration/experimentation afforded by ADHD which carried you to self-discovery of, say, why SIN relates to COS through their derivatives, or through the Pythagorean theorem, doesn't actually get you very far in calculus unless you intend to re-invent, at great personal cost and to no practical advantage, a lot of very well-known wheels.
Instead you need that hard-won scaffolding of rote memorization, the almost muscle-memory capacity for sight-recognition of a couple dozen identities and theorems and familiar problem forms, to get much further.
Spontaneous yawning when you're wide awake and actively interested in what you're reading or learning is for me a telltale sign that I have reached the point where I'll I have to tack a frustrating zigzag course _against_ the ADHD winds instead of sailing with them.
The big problem with hyperfocus: you don't control what you focus on, or when. You can't turn it on for the big project, or turn it off when you're hyperfocused on a dumb distraction. Even ordinary focus (non-hyper) comes and goes at inconvenient times.
(I'm not sure if this is what you're saying, but hyperfocus isn't a fixation on a field of study or area of work. That sounds more like an autistic special interest, although many people with ADHD also have autism. Hyperfocus is more like being "in the zone", on a scale of hours.)
Some ADHD people find great success in the workplace, because of or in spite of ADHD. But non-traditional career paths have a ton of ADHD people for a reason.
Things that come to mind are data science/analysis, debugging and fixing outages (finalizing follow up RFO might be hardest part ), security/hacking (hopefully white hat)...
And basically whatever else one personally finds interesting to dig into deep and/or wide.
Most jobs would not afford me this, but I lucked into a great role that plays into it rather than fights it.
Where you intentionally have more than 1 thing/project going on, so you can procrastinate on nr1 while you work on nr2 ...etc.
And for going in deep and long - it really needs to be something personally interesting.
Or someone else has a better was to get into hyperfocus flow/zone?