Obviously this is make for ripping DVD/Blu-Rays, but combined with software like Automatic Ripping Machine, I feel confident that you could automate 90% of this. (Still would need to put disks in, and rename any folders that were created).
Based on the fact that you are dealing with medical files, you likely have HIPPA hoops to jump through, so using a unmanaged second computer might be out of the question. (As an it administrator I would not allow a raspberry pi or similar access to the VPN/Network). You may have luck asking IT for a second computer (that they control), and then do the USB drive option.
Unraid- if your drives are different sizes.
Truenas - if you have lots of ram and like ZFS.
CasaOs - If you like pretty things.
Proxmox + Open Media Vault - If you want to run vms.
That article is confusing. They claim you don't need to worry, then they drop a sentence like this.
Even a worn-out SSD would still go a year without data loss, according to the original presentation, and that’s while being stored at 87 degrees Fahreneit the entire time
So which is it? If I have a SSD in a drawer I sure hope it will last more than 1 year.
All the major NAS brands have a google cloud sync (synology/QNAP/asusstor/casaos)
Owncloud/Nextcloud have a google drive sync plugin
You could use something like rsync to copy to another cloud or drive.