Both professionally and personally, I've been moving away from cloud storage - I've been a paying Dropbox user for 15 years but now, they've (IMHO) lost the plot in terms of basic functionality and performance, so am in the process of ditching them. Google Drive is a complete resource hog, has poor OS-level integration and has been demonstrated to corrupt certain types of file (especially multi-part zip files). iCloud made a poor start years ago, but I now use that for core household and collaboration. We're also heavily focussed on reducing dependency on US-owned or controlled services.
I now run a RAID5 Thunderbolt array on the house LAN. Usually used indirectly through each machine synching to it, so we're not dependent on network/server performance. I run Roon server on a Mac Mini with an external NVME SSD for local content - that backs itself up to the RAID array and the server does daily incremental backups to Google Glacier storage, using the very excellent Arqbackup package. That costs pennies and provides coverage against disaster. For my photo editing, I use a Thunderbolt 4 NVME-based DAS connected to my MacBook Pro.
I use Tailscale for external access and to create site-to-site VPNs for collaboration.
On the Mac/Win/Linux side, I've had a long career in technology and strategy consultancy, from working in the field in the mountains of Central Africa to advising major global corporates, as well as wrangling infrastructure and devops for my own startups. It may be indicative that the companies I've worked for or owned have always used Macs as their core systems, due to their greater productivity, reliability and lower management overhead - that's been true for 40 years now and, with the (albeit imperfect) Apple multi-device ecosystem, remains just as relevant today.
On the music playout side, I've compared MacOS, *nix and Windows-based playout and generally found the Macs to be most reliable and have the lowest induced noise (every Windows machine I've tried introduces some level of noise). That said, if I were still using HQPlayer extensively, I'd consider hosting that on an x64 architecture system - its architecture is better optimised for the Intel/AMD instruction sets than the ARM RISC architecture. As it is, my current DAC doesn't benefit from the manipulations of HQP, so I've set that aside for the moment.
HTH…