FWIW both CD- and DVD-RW are less reliable than the read-only counterparts. M-Disc is supposedly very good.
Tape is amazing, and resilient, but the drives are fragile and expensive.
The sad part is that Panasonic/Sony/Pioneer have pulled out of making drives (I believe Panasonic still make some for their own vertically integrated products), which just leaves Hitachi-LG.