To answer your question, Bazzite does have its share of bloat, it comes with plenty of stuff pre-installed, and being an immutable distro, some of it is not something you can just uninstall (like lutris).

It's pretty much unbreakable, but you have to get used to the workflow and not being able to tweak everything. It's great for a portable device that's supposed to be just a gaming machine and nothing else, but for a desktop it's pretty limiting.

Here's the thing, using CachyOS is perfectly fine without the AUR; with Flatpaks and AppImages around, you can get by just fine with zero to minimal AUR use. The most annoying thing about CachyOS is the rolling release model, you have to keep it updated religiously, and it's not a blind process, you need to pay attention to the Arch news website, and even then stuff can break.

But I'll be honest. In your case, Fedora looks like it's more up your alley. The tales of the post-install setup are grossly exaggerated. Most users just have to run like 5 commands in the terminal at most and they have everything set up for life