HDDs can fail too. I’d probably use a Raspberry Pi + SSD if putting it at someone else’s house, since they will both be very quiet. I have a 14TB HDD at my house for backups, and it’s pretty noisy.
If you really want redundancy you can use a mirrored array but for one backup of multiple I probably wouldn’t, especially if there’s a cloud backup in there.