Pretty much any major distro is going to have similar support for all of that. And for Adobe CC, that’s going to be limited at best. You didn’t specify which part of CC you need, but here’s an option for installing Photoshop 2022 on Linux. Trying to get the latest is likely going to be painful, since WINE would probably lag with supporting all the new updates.
Steam works pretty well pretty much everywhere. I’ve used it on Fedora, Arch, and openSUSE, and I’m sure it works fine on any Debian-based distro. VR support is similar, you’re going to have a much better time with SteamVR headsets. That said, here’s a guide to VR on Linux, stick to “confirmed working” sections for minimal tinkering.
Tails
Yeah, don’t use that for regular work, that’s an uber-paranoid distro that’s intentionally locked down, which means things are likely going to be more difficult to get working.
Try Linux Mint or Fedora (or Bazzite if you want gamer flavor), they’re both solid and tend to work pretty well out of the box. Software and hardware support doesn’t vary much between distros, so if it you can’t get it working with one of those and it’s not “officially supported” (i.e. instructions aren’t in one of my links), distro hopping probably won’t help.