I only say that reinstalling is not solving a problem in the context of troubleshooting and finding a fix. But yes, is not a good solution because it is a pain. I did so much reinstalling in my windows years that one of the best things I did was to learn to create a separated partition to use for data because it make reinstalling so much easier (it was back in the days of winME and it was an event to do a reinstall, we would usually go to a friend’s house with the HD or the whole machine just to be able to backup everything).
About the software it is like I mentioned (maybe in other comment) with hardware compatibility. If it is a windows first software, usually Linux support is done in “best effort”, so always lags behind. This is specially true to closed source software as the community can’t even help. In any case, one sad reality is that programmers usually are terrible at building and packaging software for release, and that is not a Linux only problem. The famous dll hell on older windows were due to terrible packaging. That is why docker is so popular, so people don’t have to bother with packaging.
For FLOSS software what I usually see is in software not on the distro repos and it not being compatible with the distro because the devs don’t build for it. With closed source/binary-only what I see the most is broken dependencies because they build it wrong, targeting the OS libraries instead of bundling everything with the package.
I can’t comment on the regular package upgrades without more info, if it is like OS base packages or like end user apps. In any case there has being problems with major versions with changes and stuff but if it is not a rolling release distro that is very rare.
In any case I don’t agree thad service packs are the same as OS version upgrades, and if it was recently win10/11 had some very bad updates that broke people workflows and features.
I don’t know if there is any LTS distro with Wayland by default. I don’t use LTS distro nor Wayland (nothing against it, I just didn’t have a need for it so far so my lazy ass will not update). But Wayland rollout has being a disaster in any case. That is completely valid. The only thing I will say is that I don’t think that there was any distro that changed to Wayland as a normal update, was always during a version change and as such, of course, doing an upgrade with this major change probably broke a lot of people workflows. The Nvidia situation in the Wayland matter also didn’t help at all.