Generally; CachyOS is Arch Linux, which means all the good sides and down sides of Arch.
Bazzite is universal-blue. Which is immutable Fedora. You can’t really mess around with the system. You install software via flatpak, everything is a very controlled environment.
Depending how familiar and comfortable you are with linux, that could be right.
Bazzite is a dependable experience that you setup it up to do a job and just use it. Tinkering around with it isn’t really a thing.
CachyOS being basically Arch with some performance based modifications is absolutely for tinkering with, customising, learning to get under the hood with Linux… but also very breakable.