I use Fedora as my primary desktop distro. It's a sturdy base with relatively up-to-date packages from the repos. It doesn't really push technology I consider undesirable, like Snaps. Even though I have to rely on RPMFusion for a number of proprietary parts, due to Fedora's free software stance, I don't have any particular qualms about that. I also increasingly use Flatpaks anyway.
When I used to use Reddit the /r/fedora community was helpful and welcoming.
One downside is because the kernel changes frequently, and I (sadly) own a Nvidia GPU, akmods runs very often. Another downside is sometimes that frequently changing kernel can cause issues. I think in the past year or two I've had two distinct occasions where a kernel upgrade caused my mounted shares to not mount correctly. Reporting an issue to upstream also takes quite some involvement, as I discovered when I had to create some Red Hat account to report an issue about the packaging of some software in a beta release of Fedora.
So all-in-all I would say Fedora is a strong distro. It is probably not the most beginner-friendly one, though, given how you have to dip your toes into RPMFusion and related challenges. It used to be worse, since DejaVu used to be the default font system-wide and you had to install a fonts package from COPR to make the system actually look pleasant. Since then they switched to Noto, which makes the font situation MUCH better.
On servers and VMs I use Debian because I do not have the patience to maintain a faster moving Fedora multiple times over. This is exacerbated by the awful defaults of Gnome, which I have to bend into shape with extensions. When Fedora 40 releases later this year I fully intend to reinstall from scratch since KDE Plasma 6 will be available.
edit: i misread the prompt and just talked about my favorite distro that i actively use. whoops.
My least favorite distro could be Manjaro if I actually used it, but it is Ubuntu because of how close it is to being a great distro. Snaps really soured me to that deal. Snapd and Snaps make it difficult to use in VMs, too, because now you have to over-commit resources for something that could and should be smaller and simpler. Debian stays winning, as usual.