Has anyone done this, and if so any info. would be appreciated.
Are you talking about amazon.com/clouddrive ? If so its possible to backup your VPS as a whole with rclone. The only way I could see backing up cPanel backups is if you set it to generate one on your VPS itself which would require you to have the storage to do so on your VPS and set it to backup that directory.