I haven't used LTO. Looking at the description on Wikipedia, LTO looks excellently designed.
I used DAT/DDS (didn't have a choice - was given all my university projects on a DDS tape, couldn't read the data when I got access to a drive sadly), and I won't be using that again!
No really, LTO are the only tapes you should use, the drives are backward compatible and quite cheap if they are from an older generation. Cerns CASTOR system mainly relies on LTO-Drives/Tapes
"Only wimps use tape backup: _real_ men just upload their important stuff on ftp, and let the rest of the world mirror it ;)"
https://www.webcitation.org/6P8EBZqQX