On the topic of audio production, here are your options:

Commercial DAW apps available on Linux: Traction Waveform Reaper BitWig Studio Presonus Studio One (beta) Harrison MixBus (based on Ardour) ReNoise (tracker/daw hybrid)

Available sources but commercial binaries: ZRythm (currently in beta) Ardour (can be found for free on the repos of most distros)

Completely free: LMMS (recording live instruments is available via the latest nightly build, but no vst3 support) QTractor Stargate MusE Rosegarden Traverso (active again this year) Ossia Score

Audacity (audio rec/editor) MilkyTracker (tracker) SoundTracker (tracker)

Hydrogen (drum machine) Cecilia (audio signal processing) Mixxx (live DJ)

To get these working, install pipewire-jack on your distro and enable some audio group privilliges, so you don't get cracking sounds. There are tutorials on how to set that up. Also use the qwpgraph app to create audio connections (otherwise, you might not hear anything coming from your speakers on some plugins/apps). My favorite free daw on Linux is Ardour. Reaper if I want to get more involved.

There are a number of native Linux plugins that should be prefered, but if you want to run specifically Windows plugins, you will have to install Wine and then Yabridge. Yabridge acts as a bridge between the .dll plugin files in a Wine environment (that is setup as if it's Windows), and serves .so Linux plugins that Linux DAWs can understand. This is obviously quite flaky. Different versions of wine will support different plugins. Sometimes, a plugin works, you upgrade wine, and it no longer works (but some other plugin now works, that didn't used to be fore). Some people are happy though with yabrdige and wine. I find it a pain...

I'd suggest you go with Fedora, so Resolve works easier than it would on a Debian-based OS. Also, Yabrdige is currently broken on ubuntu. The dev said he might fix it by the end of the year, but who knows. I'm personally ubuntu-based and I'm still telling you to use fedora to get that stuff working for now. Although, you might want to try the UbuntuStudio flavor. It might have some of that stuff fixed.

For photography, use Darktable. For raster editing, use Gimp 3.0-alpha (the 2.10 version is not that good for people coming from photoshop/windows IMHO as it lacks adjustment layers), and Photopea on the web browser. For vectors, inkscape, or online, boxy-svg.com.

For an After Effects clone, there's a brand new app, Friction: https://friction.graphics/

For a video compositor, if you're not going to use Resolve's Fusion, there's Natron (Nuke clone ui-wise).

For digital painting, there's Krita.

For 2D animation, there's Krita & Friction above, but also Pencil2D and SynfigStudio (latest version .appimages on their respective sites).

I'm not familiar for apps regarding web design though. There's Bluefish for html editing, and you can use sublime-edit for other code-writing.

For Office, LibreOffice comes by default in most distros, however, the highest compatibility rate with MS formats is via OnlyOffice. You can download an .appimage on their website for free. That app will let you create proper PDFs too (with forms etc). To run appimages, download them, right click to go to their file properties, and there make them executable. Then double click them to run.

For 2D CAD, use QCAD (you can download it from their site, and then remove the .so files it directs you to, to turn it from demo/evaluation to the completely free version (that's missing some format support, but otherwise fully functional). For 3D CAD, there's the RC2 version of FreeCAD.

And for 3D stuff, there's Blender. Latest version available on their site in binary form.

Finally, if you're not doing highly advanced color grading, or you don't need your videos to be color managed, then both Kdenlive, and Shotcut are very good, hassle-free video editors. You can download their .appimage file for latest versions from their site.