At this point in time, for cold storage/backups, I would only look towards a HDD.
So I've been doing a lot of research lately because this has been bugging me a lot. Trying to search for anything about this topic is a bit tough. Most of the information out there is at least 5 years old. With cloud storage being the norm for long term reliability for consumers, and data centers favoring cheap storage space, power-off data retention is kind of ignored these days. This is rarely an issue or selling point for people nowadays, and it seemed to stem mostly from past concerns over SSD reliability which people don't care about much anymore.
However, I have been able to reach some conclusions that are quite surprising. JEDEC standards, some articles by independent authors, and data sheets released in the past by some manufacturers have allowed me to piece together a good-enough idea about data retention and how to maximize it. It's all about how quickly electrons leak from NAND cell and how difficult it is to read the correct voltage in NAND cells. A new MLC drive with zero write cycles should hold the data for at least 10 years under normal conditions. Write cycles, bits per cell, storage temperature, and reading temperature are all very important factors in how long the data will last, and all under your control. So, if you buy a new, unused MLC drive, write data to it once, keep it at 25 degrees Celsius (or below?), and then warm it up to at least 40 degrees Celsius to read it, it will be pretty much guaranteed to last 10+ years without power. I wouldn't rely on that, but it is good from a fail-safe point of view.
There are three variables I can't account for however. Those are how good the controller is at reading NAND cells, which should be expected to increase over time, how many electrons are stored in each NAND cell, which goes down over time as manufacturing processes get smaller, and how the design and manufacturing quality of NAND cells, which should hopefully increase over time.
Because it's solid state, as long as there aren't any manufacturing defects or it gets physically damaged, there should be a greater chance of the drive working again if it gets connected to power than say a mechanical drive.
One interesting fact is that newer flash memory has 100 or less electrons per cell. In QLC you can imagine it doesn't take many electrons to leak from a worn memory cell for the bits there to be permanently corrupted. The controllers are better than ever, but they need to be kept powered on in order for them to work their magic in retaining the data on the drive.
Unsure if that is also your reddit account, but seems right up your alley for a thread.
It's not. That's just a coincidence we asked a similar question at the same time. I do know HTWingut though. Used to argue with him a lot many years ago.