At my new job I interviewed into a promotion and am a team lead. My focus is always on whatever is the most challenging technical tasks. Once we finish building a product, someone else takes over maintenance and we get a new project. It’s fantastic because I’m always at the edge of what I know and writing brand new stuff, which I exactly what I love. I find this deeply satisfying and it helps rebuff that feeling of being a fraud. I definitely prefer to be a medium sized fish in a small pond (where I’m a pretty smart guy at a place that doesn’t necessarily need world class engineers) vs being a medium sized fish in a large pond.
The more boring my work is the worse I do at my job, and I’m lucky that in my position at this point I basically only focus on the novelties and intricacies of the most challenging tech problems the company has to offer.
This is imposter syndrome[0]. Particularly feeling like a fraud, disassociation from compliments, and expecting people to find out you're a fraud. I think it's fairly common for some jobs/roles (software developers at Google, for example). I also think it's fairly common for people with ADHD.
You can still do more and do better (e.g. by better coping with your ADHD symptoms), that's normal and healthy to an extent. It's just that your self-perception is probably a bit too negatively biased. It's normal to have a negatively biased self-perception, but my guess is that your self-perception got warped a bit too much from decades of "sheer terror".
I can't really speak directly from experience with imposter syndrome, but what currently helps me deal with negative self-perception is acknowledgement and acceptance:
* cognitive reflection: Understand and acknowledge that many of my self-thoughts are negatively biased[1].
* meditative reflection[2]: Practice unconditional acceptance. Accept everything, accept my own performance, accept my negative thoughts of my own performance, accept my feelings of ineptitude.
... Unless "I'm only accomplishing a small fraction of what I could... I expect people to realize that any moment now" actually means that you expect people to find out that you're secretly really awesome and deep-down you're actually way better than all of them. That's probably not imposter syndrome.
[0] https://en.wikipedia.org/wiki/Impostor_syndrome
[1] https://en.wikipedia.org/wiki/Cognitive_distortion
[2] I don't really meditate per se regularly, I'm trying to illustrate that there are different ways to mentally reflect. Rational, logical, emotional, spiritual, whatever.