Right?
My ADHD is shaped like this: Hyperfocus on a new interest. Read everything about it. It's the best thing ever. Think about it while doing other things. Then about a week or two later, I have 6% less fun when I do that thing and it's time for a new interest.
I'm honestly very good at many things you can learn in a week or two for this reason. I also have at least a laymen's understanding of many, many topics. But I am an expert in nothing.
When I'm very lucky, my interests overlap later and I can look like a pro when I "just started" this new hobby.
Plenty of non-gaming examples but one that comes to mind is Besiege / Trailmakers. I loved Besiege deeply for about two weeks. Built everything you could build in that time. When I played Trailmakers, I was outbuilding my much smarter friend because I already had a pretty good understanding of how the gyros and logic blocks would or wouldn't work in that type of game.
ADHD really is the perfect example of a blessing and a curse. A superpower with an equal and opposite cost.
For longevity?
Satisfactory and Elden Ring.
Honestly, something like Call of Duty or fortnite might be nice too. I haven't played in years but the skill ceiling is very high so it could at least keep me occupied for a very long time.