Linux

Ubuntu LTS

You seem to have actual work to do on Linux and a large suite of software to get working. This will be your most significant challenge. Ubuntu is one of the default targets for nearly all software projects, open source or proprietary and if there's any documentation or information, Ubuntu will be in it. This alone will give give you a ton of mileage. You probably don't want to add the difficulty of figuring out why something written and tested for Ubuntu doesn't work on another distro. Resources like wiki.ubuntu.com, help.ubuntu.com, askubuntu.com and discourse.ubuntu.com are there to help.

Pretty much any distro will do, but Ubuntu-based ones tend to be easier to use due to having menus and buttons for most everything. As for apps, here are my suggestions

~3D~

Blender

~DAW~

Ardour

LMMS

Bitwig

~VIDEO EDITING~

Davinci Resolve (if on Nvidia)

Kdenlive

Olive (alpha software, be wary of crashes and save often)

~IMAGES~

GIMP

Krita

Photopea (web app)

Inkscape

Lights may be possible with OpenRGB but I haven't personally messed with these kinda of software

There already good recommendations, so i'll just add that you shouldn't make your work life harder for the sake of running Linux.

Definetly give it a go, and see if it fulfills your needs, but maybe hold off on nuking your Windows install until you are satisfied.

I use my Linux computer for personal stuff and some work stuff (web-browsing, email, office suite) and i have a separate Windows PC just for running applications specific to my field, which don't have Linux versions or alternatives (or where it makes the most sense for me to use the industry standard)

Most mainstream distros will work with pretty much all of the software suggestions. I tend to avoid recommending Ubuntu these days as Canonical have some stubborn ideas regarding things (snaps should have been shelved long ago in favour of flatpack), that said, PoP-Os is an excellent choice for buntu based without the snaps.

Video,editing: shotcut is pretty good alongside Kdenlive. For anyone working with audio, Audacity is a definite must have for track/sample editing and effects. Whilst Ardour is an extremely capable DAW, there are others you might want to check out, LMMS is a nice sequencer (fruity loops) DAW for example. On the professional side there is Bitwig (never used it but heard good things about it) and my personal favourite Reaper.

Fedora or Ubuntu/Ubuntu based both are very beginner friendly and stable, both have wide community support and both have user friendly app centers.

I'd also recommend Ubuntu LTS or Linux Mint. You may need to add a startup flag or swap to a low-latency kernel but since the mainlining of some features, a special kernel is rarely needed. Basically, keep an eye out for latency-related audio issues and take action, if needed.

For DAW, if you're not already using one that has a Linux release, you might check out Ardour.

For video editing, check if KDenLive covers what you need.

For design software, it really depends on the type of design work. There's options for about every niche, from FreeCAD to Inkscape (vector), and Gimp/Krita (raster). Figure out what your need and find the project that best suits.

Now. With all that said, I will add another thought. I'm not a fan of Apple but, if you find that you're having too much trouble getting what you need working, I would seriously contemplate a Mac Mini or MacStudio, if you don't absolutely need a laptop. I switched my spouse to a Mac Mini w/ an M2 from Costco for her studio because of the constant instability and system-breaking "updates". It's less tinkerer-friendly but that's not its purpose. It is there for DAW and related duties, nothing else and it works great for that use case, letting me focus on FOSS stuff elsewhere.

EDIT: To clarify, it was MS causing the instability.

I recommend Linux Mint. It's based on Ubuntu with all the same benefits but without the drawbacks. Mint is lighter, faster and very stable. Looks visually similar to Windows and is more complete and ready for use than Ubuntu.

Ubuntu uses the Gnome desktop which is heavy on RAM and needs extensions to be really useful. Mint uses their own Cinnamon desktop and it's highly optimised, full featured and ready to go.

It also automatically makes backups of your system incase anything goes wrong.

Highly recommend.

For light shows (dmx related) i use "qlc+", video editing "kdenlive" and the Linux show player is great (no open source software in that field on the windows side..)

Maybe check out Pop! OS

But, yes, nearly all linux software will run on any distro. And even a fair amount of windows software will run on any of them with WINE (or VirtualBox if desperate). Occasionally commercial software will get packaged in an "installer" format a particular distro doesn't know how to install. A fairly rare situation, for which there are almost always work-arounds. You can cross that bridge if you ever encounter it.

@StrongFox Give a try Tromjaro. User friendly and very well maintained.