imho, there are many guides about picking Linux distros, but not enough guides on using distros. I think people are distro hopping because they don't know how to actually solve issues on their distro.
ubuntu,debian - for beginners. fedora,garuda - average. arch,blackarch,kali linux - for experienced. But do not forget that the distribution depends on your interests and actions.
It's called trial and error, not enough people nowadays are taught how to fend for themselves against their daily problems. All my computer problems ranging from "how do i get this program to do what i want" to "how do i get my computer to POST again" was solved via trial and error.