Cloud Backup for NAS -or- Ditch Synology and Cloud Storage?

I realize this is a synology sub, but today I've hit my whits end. I am a one man print business and we purchased a DS923+ two years ago to setup a file server that serves as an artwork archive for older jobs that either haven't been printed in years, or, don't get printed very often. Occasionally we have a customer pop up after four years and need a re-order so we'll jump into the synology and pull some old files via Wireguard from our main MacBook Pro Laptop.

Half the time wireguard/SMB won't work properly - wireguard will connect to the NAS, but the SMB connection fails initial connection. When it does eventually work it loads folder painfully slow (from MacBook Pro). Even accessing through local network as a shared folder, folders are incredibly slow to load. From my research SMB protocol from Mac is just terrible with Synology.

And don't get me started with Hyperbackup and it's inability to just delete oldest version of backups when the USB external drive is full in order to keep going.

I just feel like it's been constant frustration with this NAS. We had the USB backup drive fill three weeks ago and have since reformatted it, re-setup the hyperbackup task and it will not backup successfully...we've tried four or five times now and it's just stuck on the new initial backup after three days.

So i started looking into CLOUD backup. But then I started asking myself why I'd pay for cloud backup when I can just pay for cloud storage and access it everywhere flawlessly and consistently - and it's automatically backed up. So that being said, I'm asking for opinions and guidance - without judgement. Should I ditch the NAS and just pay for monthly cloud storage and use that? The total space taken on the NAS is \~1.2tb.