OK, let me fill you with my experience. Now I am on Desktop Linux, and I can't say how your Double Touch screens will work. But I can tell you about some of your points.

Affinity, canva, corel, and cinema4d are not Linux compatible and you'll need to run them in Wine/Wine GE via software like Bottles or Lutris. Most will not work, while others like affinity might work, but requires a lot of working around. If these software's are required, you may want to look at a Mac.

keyshot, gimp, vscode(ium) are all native and have either scripts or can be installed via Flatpak or from the distros app repos.

Davinci Resolve is interesting, You've lucked out since you have an rtx2060, but Resolve is quite finicky to get working Linux. You'll need nvidia drivers and the open source free drivers will not work. All good Linux distros should have easy access, but I found Fedora to be trickier to install. Once you can get Resolve working, you'll either need to buy Studio if you want H.264 support, and if your videos aren't using PCM audio then you'll need to convert it using FFMPEG. I have a script which I use at the end of my injest. Afterwords, it runs and works fine, with no issues (assuming you have the RAM to run it 32GB recommended). If you don't want to deal with any of this (understandable) Mac OS has no issues out of the box.

Working file explorer: up to taste, and personal preference. Every distro will have one and it'll be good enough, but some distros tailor theirs to their OS's tastes. If you are running with a popular Desktop Environment, i.e. KDE Plasma, Gnome, Cinnamon, then it'll work.

Now if you want my two cents on all of this. First you should aim for a Ubuntu based distro. While Ubuntu itself isn't bad, I personally prefer a different Desktop Environment as Gnome is too different for me from what Windows offers. Linux Mint with Cinnamon and POP_OS are good alternative with a more Windows/Mac flavoring, and since they are running Gnome underneath it'll have the same compatibility as Ubuntu proper with hardware.

Another option is Kubuntu which used KDE's Plasma. Plasma is OK, but I find it to be a little less refined than it's appearance lead me to believe.

Now for testing, I'd advise you to get a second SSD and an enclosure and plug it into a USB-C port. It'll do wonders to quickly go an run everything, without sacrificing you existing install of Winblows. Linux is so efficent I ran my main PC for a week off of it, and only noticed while running games.

Finally, depending on how often you are using your Windows only software. You might get away with running them in a Windows 10 VM, and using a shared folder to the Host machine to move files back and forth.

This is definatly a project you should look into, but I feel you should probably look at more cross platform alternatives to your software first. Since another alternative, if you aren't playing games, is a Mac.