Eh, I have used KeepassXC over multiple machines using NextCloud to sync it for years now and have never had any conflict.
Canonical might only care about Snaps, but like I keep saying you can just enable Flatpak and get it from there. Only if you want debs you'll have to move away.
But KDE never will be exculsively available as snaps. Again, you can just install Flatpak and get them from there. Or get Debian and stick to .deb, it's largely the same base as Ubuntu anyway.
You can as of yet still disable Snaps entirely on *buntu and enable Flatpak instead. I doubt you'll be getting them as regular .deb packages for long still though...
Still is, it's available on FreeBSD and OpenBSD
Eh I self-host and that works just fine, I haven't noticed any breakage.
Why do we need a new Newpipe? There is also LibreTube already which imo is already better than NewPipe as it for example has sponserblock built-in (which NewPipe refused to add).
I personally rent the cheapest VPS I could find and put Tailscale on it. My server at home then connects to that Tailscale network and the VPS runs nginx acting as a proxy forwarding everything to the server through Tailscale.
Besides having no annoying networking issues it also has the benefit that I can move houses without having to update A records to have the domain point to the new IP address because the VPS IP ofc remains the same.
The reasons for choosing Musl over glibc are largely unrelated for choosing a service manager. You can want one without the other just fine.
In general (there are exceptions) containers do not use service managers at all. They start 1 command and that's it.
Note that the actual latest release is 1.2.5. This is just a patch release for the 1.0 series.