Regarding the stuff you want to do: it doesn’t matter what distro you pick, they can all run the same stuff anyways.
I would recommend something Fedora-based, because that’s most people recommend. It’s very sane and user friendly. Bazzite would be the best pick imo, but the classic Fedora KDE variant is also good for most people.
All other of your questions, like gaming stuff, are (or will) be answered anyways by a dozen other people here.
But I can give you some perspective regarding CAD and video editing.
CAD on Linux sucks.
Most is made as Windows only, and many people have tried running it through Wine (Bottles) or other janky methods. Don’t even try it.
FreeCAD is also not the best choice in my personal opinion, especially if you come from other CAD software. But you can try it of course, maybe you’ll like it.
The only “proper” recommendation, and what I also use personally, is Onshape. It’s browser based, intuitive to use, has a good UX and many features. Downside: it’s proprietary and browser based, including all your files. If the company behind it decides to piss in your face, there is nothing that will stop them.
Video editing is a lot better.
As you already mentioned, there’s Davinci Resolve, which is available for Linux too.
I recommend you, especially if you choose Bazzite or any other distro where it isn’t available officially, to check out Distrobox and install it from there, so it won’t mess up the rest of your host OS.
But maybe try Kdenlive first. It’s a one click install and works great too, while being FOSS on top.





What does it do better than Aurora/ Bluefin for example?
They offer the same pros - easy (no) setup, impossible to break, no maintenance, etc.