Tape is still more compact than harddrives, and some times cheaper. But once you start adding in the cost of the drives, it's only really worth it if you're backing up a lot of data.
For LTO7 that's about 100-150GB, less than that and it's cheaper just to backup direct to a pile of harddrives.
(Based on a quick spreadsheet assuming fitting 6TB on a LTO-7 tape, and prices of about £50 per tape, £2000 for a tape drive, and £130 for a 6TB harddrive)