Magic drugs

Every once in a while I read posts/accounts/experiences of people with ADHD online and think "hey, that all sounds very familiar;" to the point where I have looked up ADHD symptoms multiple times only to realize that I almost certainly don't have it, there's just a huge overlap between symptoms of ADHD, depression, and anxiety. "Shame," my stupid brain thought, "because if I did have it, I could get magic drugs to make my brain work better." (I know it doesn't work like that.) Only to remember that I do take magic drugs to make my brain work better, they're called antidepressants. …but I would like better magic drugs, that make all my brain problems go away. Hmpf. (I did talk to my psychiatrist not too long ago and my drug dose is fine/good enough that I really don't want to experiment rn.) Instead I get advice like "get enough sleep, liquids, iron, vitamins, and exercise," aka the slow way. I'm working on it, but magic would be so much more convenient.

So that got me thinking on the topic of healing spells for mental illnesses in fantasy settings. D&D has spells like "Heal" and "Greater Restoration" that removes "eliminates fatigue and exhaustion, and removes all forms of insanity, confusion, and similar mental effects." I'm pretty sure those were meant to be insanity and confusion that were created by magical effects in the first place, but would they also work on other forms? What about trauma etc.? (I bet there are quite a few powerful and/or rich people and workaholics who would try to abuse Greater Restoration to sleep less and work more, but maybe long-term that might have negative effects.) And if you only have magical spells against physical illnesses, would mental illnesses be taken more seriously or be even more stigmatized? Hm.
(If anyone knows of a canon that covers that topic I'd be interested in recs.)