I've found that adderrall, for me, has been very helpful and has not really produced any negative side-effects. I don't take it on the weekends and will skip a week or so every now and then, just to get a read on how I'm feeling without it.
One thing to keep in mind is to check your expectations. Normal stimulant dosing for treating ADHD is not going to make you limitless. Your mind will be able to stay more focused but you need to actively use that focus to start developing organizational frameworks that you can work within. Building these frameworks and habits and sticking to them was extremely difficult prior to medication but now that I have them, I find it much easier to skip the meds and still be able to be as productive as I want to be.
I would recommend you find someone who specializes in Adult ADHD, especially one that has experience dealing with otherwise competent professionals because they'll be able to help you make the most of your treatment.
Also, no matter how much you might beat yourself up over lot being able to live up to the standards you'd like, please be grateful for what you've accomplished even with your limits. Unfortunately a lot of people with untreated (and even treated) ADHD fall into vicious cycles of risky behavior and end up with crippling addictions to drugs, gambling, sex, and other dopamine-producing behaviors.