I was diagnosed as a child. I don't... I don't think I would have a lot of the coping strategies I do have or be as functional as I am if I weren't (even though I've never been on meds). I suspected being medicated would be better (I am also in my 40's), but at the same time it is very hard to get past my executive dysfunction in that regard. I think I also worry that being medicated will help very little/not at all and my expectations will be shot to hell.
I don't know if this perspective helps at all.
But for what it's worth, being diagnosed may afford you some other support systems that might help you at work and in your professional life.