I recommend a high quality SSD and HDD. I don't want an SSD with anything lesser than TLC. If you're SSS fails, it could be a capacitor. Replace that the drive may work again with data intact. I never compress data. Increases chànces of data failure and there's no longer a need. The last time I tried, it was in the mid-90's and the reads was too slow. Soi never bothered with that again. I just buy another drive.
It does not matter. For the end user, the reliability of any SSD/HDD is always 50/50. If your valuable data is in a single copy, you have already lost it. And that means a person is either stupid or does not consider this data valuable.
Getting data out of an SSD is nearly impossible, even at professional recovery companies. And new HDDs also have encrypted firmware, so there are already few chances with the replacement of mechanics and electronics from a donor, even for a professional.
Only multiple backups - at least 3-4 physical storage devices and preferably 1-2 copies geographically in different points, will save your probably valuable data.
It is obvious that modern helium HDDs are not reliable storage in the future 10+ years.
DVD/BD are too small. And as shown by multiple studies - two-layer / three-layer BD-Rs are notorious. Thus, with the growth of volumes (and many, like me, have been writing home history in 4k video for many years) exponentially, only HDDs remain without helium and faith in success with several copies...