I dislike anything that comes out of the Apple ecosystem. Keep that in mind when I say that I agree here insofar as MacOS being a better user option than Windows at this point.
That being said, I would encourage OP in their pursuit to see if Linux can fit their needs. Anecdotally, I’ve been using Linux (Fedora, KDE) as my daily driver for years now. I find it quite polished and have no issues with finding applications that fit my needs.
Realistically though, application support can be problematic. If a specific proprietary piece of software is required or important to you and it’s not available in Linux, that could certainly be a non-starter. You could fuss about with wine and try getting that stuff working, but no guarantee it’ll stay working so I wouldn’t rely on that. I know OP is interested in A/V stuff. That’s not an ecosystem I’m very familiar with. I know it exists, but I don’t know how good it is. No harm in trying though, all it costs is time.
Arch is amazing for all of these reasons, and I agree that by design it’ll give you a lot of insight in to what’s under the hood that most other distos tuck away.
I’ve used it in the past and ended up moving away from it because it requires quite a bit more effort to maintain, which got tiresome.
Arch has an active and dedicated community, so obviously there’s a whole lot of people out there who feel it’s worth the effort. Maybe OP will too. But it’s not a distro to take on lightly.