My WD 1Tb SSD failed, but I think the laptop it was on was powered down for a few weeks. I'm not sure if that makes a difference.
SSDs do have an issue with data that sits unpowered (bit rot, where the charge in the cells leaks out), but it's in the range of 5 to 10 years, not a few weeks, unless there's a defect or it's in an extreme environment. (And that can be a single-unit defect or an overall design defect, but that type of design failure hasn't happened for many years.)
Duplicating the data to multiple internal drives is kind of putting a lot of effort and cost in that doesn't gain much. The main drive and one internal copy is plenty, and an external drive copy is your savior copy. There's really no point at all in having a third internal drive.
A Western Digital USB drive would be my recommendation. "My Passport" models are reliable and have good performance and include password protection/encryption if you wanted to use it. They also include backup software. Elements portable are almost the same drive and usually but not always cheaper. I stopped touching Seagate drives years ago, and Toshiba just doesn't have anything to make me use or not use them. I'm afraid to use any of the no-name brands on Amazon.
I'd also personally recommend just setting up a backup application to perform backups nightly to the USB drive. There's really no point to doing a lot of manual copying or setting up apps that only sync certain files. Just use a backup app that does a full image-based backup and if your main drive fails you can quickly restore and be back to where you were, rather than having to reinstall a bunch of stuff. I like Macrium Reflect but they stopped making their free version (though the last one still works if you can find it), and there are several others that all work fine. With 250GB of used space on my system, for the volumes I back up, a 500GB external SSD gives me enough space for a 2 full backups and 1 week of differentials before it wipes the oldest one. Syncing to Google Drive for particular folders provides offsite protection of the essential data. I wouldn't even consider having even one additional internal drive for making copies of files, let alone two.