Yes, ADHD is terribly named as it's really nothing to do with a deficit in attention. It's more not being able to direct your attention to where you want it. It sort of directs itself 
Executive Functioning disorder would be a better name, although if people don't know what EF is, they might think it means you can't function at all!
I manage mine much better these days. I have managed to identify some good strengths as well - not just the usual "We're so creative and fun!" - I mean OK, those are strengths, but they aren't the kind you can mention in a job interview.
So realistically:
- We tend to be good in a crisis. When the shit hits the fan adrenaline hits us and we tend to thrive on this and maintain a calm and methodical approach.
- Our knowledge might seem random, but it's like a honeycomb - it's full of deep, rich pockets - we tend to know things in many different areas and we won't just know one random little fact but we will have an in depth understanding of it. We tend to be curious and want to keep digging and find the end of the trail. We're not satisfied with knowing a fact without wondering "Why is it that way and not another way?"
- Ability to think outside of the box and come up with many ideas on any given topic is also a plus.
- I have so much practice at being unprepared that I can "wing it" in almost any situation that leaves other people panicking. (Dunno how to word this better though :o) - Works well under pressure, is resourceful?
I know I would not go for any kind of resource management type position, because managing and organising is not my strength. But I work well with people because every day is different and there's always a new challenge, and my brain likes that, it thrives on novelty.
Emergency Services work is good for people like us, if you're physically fit or willing to get there (esp for Police), OK with risk (esp for fire) and OK with blood (esp for Paramedic). If none of those things apply, being a 999 call handler is a job I think would be really interesting and worthwhile.
I've done ESL teaching which is fantastic and has allowed me to move abroad. It's tricky to do it in the UK though. I've enjoyed retail but there isn't much scope to move up if you're not a management type. Sales and customer service we tend to be good at - because we get that detailed level of knowledge for the product range and that comes across well to the customer. So you can take the retail experience and move from there into sales or customer service if you pick a product area that you know well, either from previous retail experience or personal interest.