As far as I can recall, tape backup systems have never been a consumer product. At least, I don't recall tape systems ever being marketed that way
QIC, Travan, Iomega Ditto, and DDS (DAT) tape drives were all marketed as consumer products in the 1990's.
In 2000 a DDS-2 tape cost $4.47, with a capacity of 8 GB (compressed): 56 cents per gigabyte. A 9.1 GB SCSI hard drive cost $385: $4.23 per gigabyte. Reusable optical media was not cost effective, and there wasn't anything else (that I can remember) with both high capacity and low cost.
(QIC and Travan drives were cheap, but the tapes were expensive; around $30 per tape IIRC. DDS tapes were cheap, but the drives were expensive; $700 for a DDS-2 drive in 1997.)