HDDs unfortunately also use flash memory to store Bios/firmware and this memory is located on the PCB of the HDDs this would be a problem if they corrupted the HDD unusable
This seems like a reasonable order.Yes that is also an issue, but generally it will be less prone to corruption than your SSDs, flash drives, or SD cards. Honestly nothing consumer grade besides optical media are particularly reliable as archival/cold storage unfortunately, but if I had to order them it would be Optical > HDD > SSD >= Flash Drive = SD Card > MicroSD.