They also limit you by installing some stuff you'd like to get working. It's a double edge sword. I'm not saying you can't get around it but for newbie it can be a big hurdle.
I just use regular Fedora 42 Workstation and it works without issues. Bazzite is basically gaming focused Fedora 42 Silverblue (immutable) but I personally don't like immutability.
CachyOS is worth a try as well, that's a gaming focused Arch distro, though I just like Fedora too much and didn't enjoy using CachyOS
Honestly though, any of those will work fine for you, especially if you have no point of reference to compare in between them.
I think I've actually touched CD/DVD for the last time in 2012/2013... I should be fine