Your son will be fine, so long as he is weeded off these ADD and ADHD drugs within the next couple years. Use of these meds in your early teen years is easily waiverable, and may not even require a waiver depending on the circumstances. *The sooner you can get him off these, the better his chances will remain* (if you are certain he can perform fine without them, by all means do it)
However, if your wife loves medications and feels that all psychiatric recommended drugs are good for kids, then use caution. Depression, anxiety, bipolar drugs, etc. are not waiverable, and will likely end his chances.