Firstly don't try and run a corporate level backup solution or NAS with terabytes of storage and tape at home. You're going to drop dead one day and everyone will hate you for what you leave them to deal with. They will have no idea how to pick through the remains to get important stuff out. It took me a whole 3 days, as someone who knows how this works, to get into a dead relative's NAS appliance and find any mention of any info to get into his EV which had basically bricked itself in the driveway while he was in hospital.
Secondly, delete everything. Not joking. Delete as much as you can. Everything you've watched, delete it. All the old emails, delete them. Tracks you don't like on CDs you've ripped, delete them. Old software ISOs, delete them. Thousands of photos of the same thing taken 1 second apart, delete them. Thousands of PDFs of books you will never read, delete them. I went down from a whopping 8TB to 300Gb doing that and it's still shrinking monthly. Eventually it'll fit on one mediocre computer and that makes life so so so much easier.
Then look at your backup strategy. It'll look simple then. Mine is three external disks.
1. 1TB T7 shield (not encrypted) which lives at my partner's house and gets an rsync once a month.
2. 1TB T7 shield (encrypted) which lives in my bag and gets an rdiff-backup once a week.
3. 2TB Lacie HDD (not encrypted) which lives in my fire safe at home and gets an rdiff-backup once a week.
If I drop dead, my partner can just plug the thing into her computer and get stuff off it.
I'd avoid the cloud if possible as well. One of the worst situations I've seen is someone who confidently pushed their NAS contents to S3 and then when the NAS blew up they had to pay a lot of money in transfer to get it back again. Hundreds of dollars in fact. On top of the price of a new NAS. That might be a last resort option but it should NEVER be the first line backup.
Don't make your life any more complicated than it needs to be. I implore you.