Pros and cons of getting a diagnosis?

So I have been informed by a friend/former coworker with a diagnosis of ADHD that I fit the diagnosis and I do understand why. Having read about motivation, procrastination, and 'interest-based' motivation I see myself in there. A friend from high school whose career (author) fits her well also recently got a diagnosis and it made me wonder - what is the role of diagnosis later in life?

I'm in my 40s and have changed career a bunch, usually by going back to grad school to learn something new and interesting only to find the job post-graduation is duller than I would like. I suspect ADHD is why I couldn't bring myself to complete a PhD program that seemed like a great idea until i realised it was years with no deadlines and a topic I was not 'that' interested in. Thankfully i am no longer in that program and now I work in a creative field where ADHD is fairly common and not stigmatized.

I have realized that no matter where I work motivation is an issue - unless a deadline is looming or I'm intrinsically motivated by a project. I appreciate I am lucky in that I can usually get my work done on time to a good standard and i can create projects or find things to work on that mean I have motivation enough to look good overall.

So what I'm wondering is whether getting a formal diagnosis will help me and in what ways? Did you get a diagnosis and find it helpful for yourself? Did you tell your employer? Are there reasons to get tested but not share it? Did it help you find work where motivation was less of a problem? I would love to hear from other women later in life, am very on the fence on what to do and why.