Some of our greatest minds are ADHD, probably bc ADHD brains seem to approach problems in generally more innovative/non-traditional ways than neurotypicals. It can also foster intense motivation in people. Bill Gates, for example, has been open about his struggles with ADHD. Many scholars believe that Albert Einstein struggled with AuDHD (ADHD with autism, which wasn’t in the American DSM until fairly recently).
https://www.thebrainworkshop.com/blog/successful-people-with-adhd/
https://www.additudemag.com/slideshows/famous-people-with-adhd/
The thing is, for it to be an evolutionary advantage it can’t be common. That’s one theory behind why grandmas aren’t more common in species.