I don’t have a specific answer to your question, OP, other than to say that all kids are a mix of their strengths and weaknesses, rather than defined by their diagnoses. Your kids are great examples.
I hear in your post lots of approval of your academic child and concern about your less academically motivated child. I have one of those ADHD non-academic kids, and I’d just encourage you to be as thrilled by his social strengths as you are by your other son’s academic strengths. A kid who makes and keeps friends has tremendous skills that will serve them well over a lifetime. He’s figure out school, even if it isn’t always in the way you’d like!