Used Tape drives often had the write heads service hours go well past its recommended limits. Mission critical IT systems don't get "upgraded" off schedule very often. ymmv

Anecdotally, I have seen Tape sets fail in production settings, as a remote office location admin was doing incremental backups... and the sick tape drive kept silently damaging each daily roll-back attempt. They may fail ungracefully in an archival context.

I do not deny a janky BD-R drive option is situation specific, but for small projects I am fine with a 25GB disc $25.80/TiB solution with the occasional big file $62.42/TiB hit for 100G/128G EOL discs.

HDD are less hassle, still hit below $34.63/TiB, and last a few years. Not a bad fall back option if you still have old inventory. =3