I think the fragmentation problem extends well beyond "golly, which does my little head ever pick - they're all so perfectly usable I just don't know how to pick one!" and more to "well this one has Q, G, and Y... but that one has M, G, and Y but I can get Q if I tweak... and this one has M, G, Y, A, Q, Z but switching to that means I have to take its unrelated opinions on B, O, J, and N which I don't like" kind of scenario. There are plenty of flavors which can be acceptable but the premise is finding a flavor you want to use more. Without extreme ideological grounds on the level "Microsoft did ${thing} so I'm never touching them again" that becomes difficult to weigh.
I generally get away with a lot of use cases at work just saying "It's the front facing LTS of Ubuntu" and a lot of use cases at home just saying "Since it's just for me I'll customize Arch to what I need" but there are still plenty of scenarios, in each, just going with Windows makes a lot more sense (or sometimes is the only viable option, e.g. home HDR or work vendor application support).