Hyperfocus for example can be highly beneficial if you manage to point it in the right direction, and in general neurodivergence tends to specialise either into explorers or exploiters, that is, those who are good at exploring the space of possible solutions, and those who are good at applying a specific solution to solve the problem at hand. Such skills can be problematic in isolation (as you've described), but in combination can be very powerful and could've therefore been instrumental to our past success as a species.
I understand this is not much comfort for an individual who is struggling, but I second the GP in saying that many modern societies are not setup to provide the best environment for the neurodivergent among us to thrive, to the detriment of everyone.