> Debian
Release cycle extremely slow, unstable and testing don't really fix the problem, and insert their own issues. Still near and dear to my heart and if I need something pretty light, stable, but can get by with older software, it's still a solid choice for headless servers.
> Ubuntu
Ubuntu was for "noobs" probably 10-15yr after my Linux journey started. I watched them inject ads into the desktop and cli. I would use it from time to time on certain things and it would often break during upgrades. This was a consistent problem for over a decade, but it has gotten better. Now they're rewriting coreutils in rust and breaking compatibility along the way. And snap? Snap is an abomination. It is a limited ecosystem and the daemon itself is a damn attack vector.
> Fedora
Massive open source community and tons of money behind it, as it is the feeder distro of RHEL, which has been used at pretty much every company I've worked at. In fact if you use RHEL, you'll often be able to see many new features just be running Fedora somewhere else. Also one of the primary adopters and users of Gnome if you're okay with that, and I'd note of course they have a release for other WM/UI if you're into whatever. Also always seems to be a software release for it (Fedora and Debian/Ubuntu seem to be the most common big 3 for support). It uses flatpaks instead of snap, which gives you sandboxing and user-level package updates allowing your base OS to stay a bit cleaner if you want, or you can just use system packages (yum/dnf). Good on desktop and server.
> Arch
If the only person you have to support is you and you want the latest and greatest, and it has amazing community docs. Better than Debian by far, which wasn't always the case. The Debian handbooks were pretty legendary for a long time. Can be very fast and very light. Solid system.
> Alpine
You need/want MUSL and aren't using distroless container images for whatever reason.
This is just my opinion from an old grump that has a history of managing decent sized fleets of both pets and cattle and runs it at home on desktops and laptops.