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.
It sounds like your ask is for a recommendation to back up personal files from disparate locations to a server.
I use a self hosted Nextcloud instance for this purpose.