Look out for secondary school where it is much noisier and there are far more distractions, Look early and look often at the options in your area.
Some will be good at meeting his needs, some will be awkward and condemning. Speak to the SENCo and other teachers about their experience and how they manage.
If they get stuck in a groove of detentions and temporary exclusions for things that are not the fault of their ADHD kids, then it is time to be in another school.
I did hear that Forest Schools and bushcraft are brilliant for ADHD kids, as their 'disability' is a positive advantage in that environment. I can see if I can find you a link, if your son would be into cooking over a fire in a wood etc.
Our classroom environment and its expectations may make a bunch of kids who could operate in many mainstream work places into kids with special educational needs.
In the long term, the answer maybe to make the learning environment more varied so that different learning profiles had their chance to star.
In the meantime, there is nothing 'wrong' with your DS. He just ahppens to be in a minority which means it is harder to meet the expectaions of people who are too ignorant to encompass kids a bit off the bulk of mainstream kids, or bog-standard kids, as I prefer to cal them.
He will have his niche in the long run and do many amazing and wonderful things.