This is the script I used to use to manage my backups. Currently, I just take BTRFS snapshots hourly, and have an offsite backup to BorgBase via Borgmatic daily, with monitoring via both Healthchecks.io and a custom cron job that verifies the archive integrity. Although I do have other failsafes, I generally trust my live data plus BorgBase to be resilient to accidental loss.
Before I used BTRFS, however, I was doing offsite backups hourly, which was more expensive. To mitigate the impact, I backed up to a LAN server hourly, and had that server back up to cheap object storage (Google Drive, initially, then Backblaze B2) daily. Orchestrating all this, and monitoring it, was a bit complex. Hence this script.
It probably won't be directly useful to you, but it could serve as a handy reference.
It can run borg and rclone commands in various configurations, make healthcheck pings, run commands on a schedule rather like anacron, handle file excludes, verify archive size before backup, avoid concurrent executions, save log files, dynamically vary configuration based on host or other parameters, and automatically re-mount both borg and rclone archives locally to verify that files can be restored from both.