I've never had any issues with application support, but even in the worst case you can always run an Ubuntu container or something.
Granted, I specifically chose my hardware to be Linux-compatible, which meant no nvidia and a bit of googling when choosing the motherboard, but even Windows would have issues with a lot of the shoddy hardware that's out there.
As far as I can remember, nothing actually broke when doing upgrades ever.
I love Fedora's in-place system upgrade, and it just keeps getting better.
We went with Silverblue, because it Just Works™, it's simple to upgrade, and it's difficult to break (and it's what I've used for years now).
One of my criteria when recommending a distro is "if I leave them alone with it for 10 years, would it be EOL (or broken)?" and IMO Silverblue makes major version upgrades much simpler than Ubuntu.
BUT. I used to have full control. And then Ubuntu foisted snap on me and now I have to suffer the constant worry that snapd might choose to update some trivial piece of shit right when I need to be doing something actually important.
So, yes, I just did `sudo apt purge snapd` but now I'm stuck with messing with the oatmeal for a couple of applications, and that's likely to increase as time goes by.
I'm in the market for a new distro, but would prefer to stick with something based on Debian/apt because of the rich app ecosystem. Oh, and KDE.