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!
Used them at a Insurance company, they are extremely reliable.