Yeah I think about this one a fair bit.
Let's compare hyperfocus to an actual super power, like the ability to fly: "I can fly" "Oh that's so cool! Can you show me" "No. I don't get to decide when it starts" "Oh" "Or when it stops for that matter. Or even where I'm going" "That sounds... debilitating" "Yes"
This is hyperfocus. You can't decide when to hyperfocus. Or when it should stop. Or what you're going to focus on. It is not particularly helpful.
I'm 38. Diagnosed with combined (everything) type ADHD 2 months ago.
The experience for being on meds for me has been life changing. I'm on elvanse (vivanse in the US). It's like suddenly being in the driver's seat of my own mind. The guy that was driving before was an idiot. I can now just choose to do stuff.
What struck me is that not only are you playing on hard mode, but everyone else is playing on easy mode and telling you it's hard mode. "Life is hard" means something completely different to everyone else.
Definitely try it again. Medicating ADHD is really well understood and incredibly successful for so many people. I think it's insane not to give it a go and see if it's right for you.
The stigma around being medicated is completely backwards imo.