Using HDDs for backup is also a terrible long term strategy, because you must have a lot of money regularly, to buy new HDDs to replace your old HDDs and this much more often than you need to buy a tape drive to migrate your tapes.

I have stored a lot of data on HDDs, and the only reason why I have not lost any of it yet is because I have always used duplicate HDDs. After 5 years or more, most HDDs had some corrupted sectors, but they were not in the same positions in the duplicate HDDs, allowing complete recovery of the data.

The reality is that both tapes and HDDs suck. What is really needed for long-term storage is a write-once memory with a lifetime of 100 years or more, based on an open standard that would ensure the availability of readers in the future.

If such a memory would use optical reading, it would have to use a great number of layers, filling a 3D volume, in order to achieve densities comparable with the magnetic media. While several research projects in this direction have been announced from time to time, until now none of them has resulted in a commercial product.

HDD cost small dollars and low skill.

Expecting even a nerdy user to successfully restore something from a cobbled together LTO setup is prepper nonsense.