This is my problem too, why did SO decide to split the site into so many silos?
I have 10+ memberships at Stack Exchange network most of them math/programming related and it seems so silly.
Sure, keep the multiple brands if that is what your investors want but make it searchable and taggable across sites.
Often I will see a question posted on main SO that would have been perfect by the Stack Exchange rules on some other stack exchange site.
Instead it just gets closed and whoever asked must feel quite dispirited of asking again.
Yes, fragmentation is a real problem. Can be probably solved by integrating the search indexes to some measure without integrating the sites themselves. It's not easy, but it can be done IMHO.
So whilst I'll often choose an SO site I can't use their search.
Try "KDE notifications from bash scripts" for example. Google will show that there are answers on SO and Unix.stackexchange - searching at AskUbuntu (I use Ubuntu with KDE on top) will return zero results and won't even suggest results from other SO sites. SO itself has the best result but seems the least appropriate of the silos to place that search in.
Then there's having to register at each of the different sites on the network. The siloing of the site is PITA IMO. The only reason to do it this way I can think of is to separate computing resources, it seems there are probably better ways around that issue too? Why not a unified site with hierarchical tags such that you can choose a tag as a preferential search term?