Mechanical HDD’s don’t have to be noisy. I’ve just got a 1TB Western Digital Passbook one for the Time Capsual backups of my computer. Cost about £50 and is now a few years old. Runs silent as you like.
Pointless ‘investing’ in an SSD for a back up drive anyway – the main benefit of an SSD is access speed, which isn’t an issue for a back up drive. Also not sure where the latest gen of SSD’s are at, but it used to be the case they were no where near as reliable as mechanical HDD’s which are amongst the most reliable things ever fashioned by the hands of humans.
What’s cooling like for SSD’s? Do they need cooling fans? Granted it might not be an issue for a back up drive that’s not continually operating.