Why Are There So Many Neurodivergent Super-Detectives?

The list of fictional characters with relatable representation of neurodivergence (ADHD, autism, OCD, et cetera) has a lot of detective characters on it. Examples include Sherlock Holmes, Hercule Poirot, Benoit Blanc, Adrian Monk, Shawn Spencer, and Sonja Cross from The Bridge.
Some of these characters were created before the diagnoses became popular, and yet they match the symptoms remarkably well. Their special interests and hyper-focus help them notice details others might miss. At the same time, their unique way of seeing the world often separates them from society.
Analyze various fictional detectives and consider why so many of them are neurodivergent. Is there some reason neurodivergence would make someone a better detective, as opposed to some other career? Do these characters run the risk of making their diagnosis their entire personality and not being fully developed characters?