Expensive for home use, but they can buy older technology off-lease.
I can't imagine home users being interested in buying mostly used SCSI or SAS tape drives while navigating a world of format compatibility challenges and problems with improper storage. Environmental requirements for archival are narrow and most homes don't tick that box over many years or when moving.
This medium is expensive, inconvenient to use and store, and in the world of home use those are killers. You don't need to take my word for it, look around at tape home use.
Home users are better served by cloud storage or an external hard drive, maybe a home NAS, especially for the relatively low data volumes home usage usually involves.
Some years ago, after I bought a LTO-7 drive at around $3000 as a home user, I have recovered its costs after about a couple hundred terabyte of stored data.
Unfortunately, nowadays the drives for LTO-9 have increased in price, so the cutoff threshold has probably increased to several hundred terabytes.
Even when the amount of stored data does not provide significant savings in the cost of storage media, it may still be worthwhile to use magnetic tapes, for improved peace of mind and for avoiding the hassle of copying the data to newer HDDs every few years.
I am old enough to have seen enough data loss disasters, so I would never trust cloud storage, where the access to my own data would be dependent on my ability of making continuous payments to an external entity, which is really hard to predict for any distant future. Moreover, even with a fast Internet link the access speed to cloud storage is an order of magnitude slower than to a local tape drive or HDD.
The data volumes, the cost even before we look at the TCO, the performance characteristics, the time/expertise requirements, the need (hassle) for proper storage and retrieval really kill the attraction of tape for home use.
For the backup (and storage as a bonus) needs of most home users cloud or external drives are unbeatable, especially in combination.
For some threshold in the hundreds of TB range, magnetic tapes become cheaper, despite the huge price of a tape drive, while offering additional advantages, e.g. higher sequential reading and writing speeds and higher reliability.
Moreover, when computing the size of the stored data, one should take into account that the useful data size, after data compression, should be multiplied with 1.05 or 1.10, because you should add redundancy with a code able to reconstruct the data when only a small part of it is corrupted, then you should multiply by 2 or by 3, because any long-term archives must be stored as duplicated or even triplicated on different HDDs or tape cartridges, which are preferably kept at different geographical locations.
Only with such precautions you can be pretty certain that no data loss will occur after many years of data storage, reaching a reliability comparable with that of printed paper.
Cloud is not a backup. Cloud is someone else's storage.
I've had a DDS4 tape way back, which ended up dying, and that could well be the cause. My house is not going to be as clean as a server room.
I've seen tape drives taken apart and there seems to be a worrying lack of concern with any kind of air filtration on the ones I've seen at least. And I don't think it should be all that hard to deal with it. Maybe something like sucking air in through a replaceable filter and exhausting it out of the tape door.
The only options with more data capacity than a hard drive are all high end datacenter equipment. I would have had to buy fiber channel adapters and media, find a drive, a housing to put it in, and tapes. All separately, and each for several times what my entire homelab is worth.
It really is not an option for home-gamers.
It's the library/robot is what mostly matters for volume (and being able to automate). Not sure what the price is on those (along with continued support).
However, the drives are expensive. This industry is in dire need of disruption.