People with ADHD can most definitely be productive and generally considered accomplished. They just tend to have put a lot of effort in, their whole lives, in order to get there, and may have developed a lot of cool techniques to get there. Treatment itself is about improving these techniques (and finding helpful medications, the two parts work together.)
I'm quite scared of medications, tbh, but I'd very much like to explore improving techniques.
On the non-medicine side, techniques like bullet journaling are useful, also having “accountability partners” — friends or groups you report in with each week to check on each other’s progress; things like that.