I've found that the effects change massively with sleep quality. When I'm short on sleep for a few nights, it almost feels like the medication stops working. It still has an effect—I am noticeably more clumsy and forgetful without it—but it feels different and the higher-order effect on focus or executive function is less pronounced.
Another thing I've heard is that protein in the morning helps. I've tried drinking a protein shake for breakfast and it seems to make the day better in general, but with a much smaller effect than sleep quality. For all I know, it might just have been the case that I only remembered to have breakfast on days when I had slept well...
In terms of raw productivity, it can definitely make things worse (like the comment I replied to). Or at least, it can replace one problem with another – suddenly your creativity is gone and your hyperfocus is completely misdirected.
Personally I’ve sought out the (re-)diagnosis at times when I felt creativity was less of a priority than execution. If you know exactly what you need to do and can commit to it, the pills can help keep you on track. But they are not the original source of the commitment.
I’m honestly not sure whether it’s worth it, but the dopamine it releases sure does its best to convince me that it is.
You can also set timers/alarms to timebox tasks, and reign in hyper focus - it should be relatively easy to change tasks with the alarm interruption (vs. unmediated, where I find it practically impossible to move to any new task).