Don't take those memes seriously, I think the only bad thing I'd have about CachyOS is that it's probably getting popularity as a trend, which doesn't reflect on the distro itself.

In my particular personal opinion it seems like a good choice if you already know what you're doing, since it's mostly just Arch with a nice installer, which I consider to be a solid choice with good support.