If the tape drive attaches with SATA like a regular DVD drive or HDD then just get an adapter that connects USB to SATA. USB is unlikely to be a bottleneck with how slow tape is anyway, so having it internal isn’t that important.

But tape drives are only worth it if you need a heck of a lot of cartridges or absolutely need 30 year storage rather than maybe 10 years for an offline physical hard drive (assuming they’re both stored properly). Though I have drives decades old that still have readable data. But even if you copy out the data every 5-10 years to a new HDD, you’re likely to spend less than just the tape drive itself. And drives get larger over time so you’ll need fewer of them whereas the tape drive will have a set maximum storage space. And what if the tape drive dies and the company is out of business? You may end up not being able to read your tapes. SATA on HHDs has continued backward compatibility for decades.

Anwyay, for a home user with a few hundred TB to store, I’d be surprised if the cost would be better for tape. It’s really useful for places that store a few hundred TB per day, though. That’s where tape can be a boon. The primary advantages are it takes up a lot less physical space per TB and lasts longer. And once you do get past the cost of the drives, it does eventually start to be cheaper.

Also, remember it’s way slower than a physical HDD much less an SSD. Even an HDD connected via USB.