It always darkest just before the dawn. You still can succeed! My last school principal at the middle school level was highly ADHD. She also was highly successful because she realized what her shortcomings were and dealt with them (conversations with her got a little interesting because she kept switching subjects and you would have to keep pulling her back to the point - which makes me think that she was not on meds of any kind). The point being she understood what was going on and almost always found a way to deal with it. You can do the same!!!!!! But you gotta know and understand what ADHD is - then you can deal with it.
To tell u the truth I wish someone would have diagnosed me as a child. I would have succeeded so much more in life.
The very simple answer is that medication can work and will seem like a miracle - and they won't.
A lot can really depend on your doctor and the amount of time he spends working with your child. You need a person who specializes in ADHD - not a GP that will prescribe and run. The medications are all slightly different (and some that are a non-stimulant are very different) and react differently due to body weight and severity of ADHD.
There are a lot more options now then when your brother was dealing with ADHD and a lot more scientific evidence to help the doctors.
I am not sure what you have been reading but scientific evidence has shown that kids who don't receive help are much more often to have problems in later life then those that do. The medications are not addictive to a person with
ADHD, they are very addictive to a person who does not have ADHD. Remember that any medication you try, you can stop.
I think the most important thing is to realize that the meds are not an end into itself. How you work with or treat your son is equally important. There are several good books out there that will help you will he is or is not on meds. You might want to check out "Driven to Distraction" by Hallowell, and "The Gift of ADHD", by Honos-Webb. It is extremely important that your child realizes what is happening to him (and that it is not his fault). Sometimes it takes a good psychologist to do this.
I guess one thing I am saying is that (if you haven't already done so) you need to become an expert in ADHD. One source that can get you started is this article from the WebMD. It seems fairly unbaised.
http://www.rxlist.com/attention_deficit_hyperactivity_disorder_adhd/article.htm
It should be obvious to you that neither of you can continue to go on the way it is now. It is certainly time for a change listen to the professionals - hopefully, it will get only better. Good luck. If you have any other questions - ask!! And don't forget that there is also a medical forum with a doctor that specializes in ADHD that can also answer your questions. She is very good.