LTO is nice in that they mandate backwards compatibility by two revisions, which come out once every 3 years or so. So that gives you time to roll forward to new media onto a new drive without breaking the bank, and giving time for the secondary market to settle.
Adding: This was a deliberate decision by the LTO Consortium; they wanted users to perceive LTO as the safest option for data retention standards.
The amount of hassle depends on your workflow. If you create a backup every day and then bring the media off-site, tape is easier. Easy enough to put a tape in your drive, make the backup, and eject. Tape is not sensitive to shock and you can just chuck the tapes in your care or shove them in your backpack.
Apocryphal story from university - somebody did this and reckons electro-magnetic leakage from their heated seats wrecked their info
If you really need it to last and re-writability isn't an issue, M Disc claims 1,000 years.
AFAIK a post on /r/datahoarders says that the breakeven point for tapes vs shucked hard drives from a pure storage perspective is around 50TB. Given the hassle associated with dealing with tapes, it's probably only really worth it if you have 100+TB of data to store.