CachyOS, Fedora, or openSUSE for Blender and gaming?

I'd start with Fedora KDE. It's a sensible middle ground if you want a modern desktop without committing to a rolling release. Fedora still gets kernel and driver updates, so I wouldn't rule it out just because you're worried about falling far behind.

Before installing, check the setup steps for your graphics driver and the editing software you plan to use. That matters more than picking a distro by reputation alone.

openSUSE is worth a look, but the edition makes a big difference. Leap is the fixed-release option, Tumbleweed is rolling, and Slowroll sits between them with a slower rolling update pace.

For a work machine, I'd compare Leap and Slowroll first. Tumbleweed is there if you want newer packages more often, but that also means more frequent changes to keep an eye on.

CachyOS is appealing if you like tinkering and want recent packages. For a workstation where you need projects and tools to keep working, its rolling updates may be more maintenance than you want. A snapshot can help you recover from a bad update, but it doesn't replace a backup of your project files.

Check the specific games and editing tools before you decide. A KDE desktop won't tell you whether a particular game, graphics driver, or application will work the way you need it to. Try a live USB to get a feel for the desktop, then verify your actual workflow before moving important projects over.