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.
It’s like al KDE projects IMHO. Good on the surface and works well. But use it for any length of time and you will find problems, unfinished areas, or parts where it was implemented without considering why it was like this in the first place.
For example, plug your 1080p laptop into a display with 4K and watch are your desktop icon gets sorted by a-z randomly instead of keeping the order you had it.
Or try to add a calendar even to your system by clicking the calendar which is found in the date and time on the taskbar.
Online accounts added to the system do not integrate into other KDE apps requiring additional signin.
I feel this is probably caused from KDE’s team being small, but having a large suite of apps.
Sorry to hear that. Ubisoft Connect has been hit or miss for me. On my intel machine it works fine, on my nvidia machine the menu was just a black box which failed to or loaded so slowly that it was unusable. My only advice is to use the latest Proton/Wine-GE/Proton-GE and wait for updates from Ubisoft. This is all unofficial so having it work at all is a miracle.
I'm running it the latest Linux Mint running Lutris installed from their official deb file.
I had an issue with connect and the recent update fixed it for me. By if it’s the same issue I had, try running in Wayland if your using x11. Or go back to x11 if you are in Wayland.
Nah, she's toast. Ran multiple distros, and the same problem persisted across Fedora, Arch, and Ubuntu. It's also an Intel machine, and I've been eyeing a Framework with AMD. Which is why I've stated I am not looking for tech support.
Wow almost sounds like my first rig, though swap the intel with an AMD. The rig this RAM is for is my 2nd PC, since my Motherboard was compatible with exactly one other CPU, and it's still going strong despite being from 2017.
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.