In my experience, no. There are studies that have shown Fish Oil and Magnesium to slightly improve some memory functions over time, but caffeine or actual prescribed meds from a doctor have been quicker and had better results.
At least for the ADHD, I haven’t found anything for the autism front.
“Pretty whelming” is accurate. That show had so much potential and the writers just fumbled it from basically the very beginning.