Do you realize how many people have a ccw permit with your exact same condition? If I had to guess, I would say tens of thousands if not more.
The bottom line is, you are the one who is going to be responsible for your actions, not your doctor, or anyone else. If you feel you will be a danger to yourself or others, then don't carry, but just know up front, you're not alone as a gun owner or ccw holder with ADHD or ADD.
If you have not been adjudicated to be mentally incompetent in a court of law, then you are lawfully able to own guns. If you are a lawful gun owner and meet the requirements to obtain a ccw permit in your state, then by all means, exercise that right.
This is merely my opinion on this subject and in no way to be construed as medical or legal advice.