My niece has been on Concerta for a few years. She's now 13 almost 14 and prefers to take it daily than how she feels when she doesn't. She's a completely different kid on medication vs. not on medication, and I personally prefer her off of it......not my choice, I'm the aunt.
She doesn't have much of an appetite because of the medication and is much less engaged (more withdrawn) socially. She prefers to be on it in school because it does help her focus better on the task at hand.
My sister chose this in conjunction with therapy after many years of trying to figure out what was going on with her.
Each medication will react differently with each child, so I'd also recommend asking a pharmacist to share feedback with their customers. In my experience, patients (parents of patients) tend to be much more candid with pharmacists than they are with physicians regarding medications, prescribed therapy, comfortability with medical advice.
My only other comment is that I'd recommend trying both brand and generic if available. Many people believe a generic is an identical equivalent, but it's simply not manufactured the same, has different inactive ingredients, delivery, etc. So, if you've tried some others, and haven't been happy with the results, don't discount the brand (or generic) version if available as it may simply interact with your son's body chemistry slightly differently.
Best wishes.