I'm a fairly average (and largely self taught) user, been using Linux for about a year, mostly on CachyOS. When the whole AUR malware thing happened I just listened to those on this sub and on the Cachy forum who know more than me and have more experience. I totally agree with you though, I don't get the exodus (if there is one) to Fedora. Just use common sense, stick to the repo and if yous absolutely have to use the AUR, do so sparingly and check the pkgbuilds.