(Actually this problem is why I haven't owned a tape drive for a while.)
I'll get a small benchmark script for that done over lunch. Come back here later.
Is this a continuation from previous message ? Because multithreading mode of zstd doesn't impact its compression ratio. It's actually an interesting property of zstd : whatever the nb of threads used, the compression ratio remains the same (aka. reproducible).
Imagine a disk. It has two sides and a certain surface area, as well as a certain density (bits per square in/cm). A standard 3.5" HDD platter has a bit more than 4200mm^2 of surface area (having been unable to quickly find the dimensions of an HDD platter, I grabbed the dimensions of a floppy disk from the standard) per side, or a little less than 10000mm^2 per platter; I'm being deliberately rough with the numbers since all we need is an order of magnitude.
Imagine a tape. It's long and thin, and can be rolled up. An LTO-8 is 960m long and 12.65mm wide, for a total surface area of 12,144,000mm^2. Tape has a lower recording density than HDDs (LTO-8: ~20Kbit/mm * 6656 tracks, or ~128MB/mm^2 compared to ~1Tbit/in^2 = ~185MB/mm^2 for a HDD), but more than makes up for it with its length.
Also with inefficient tapes you end up spending many more tapes for inefficient incrementals, incredibly long seeks, and lack of efficient deduplication.
Then there's other nasty surprises like a relatively narrow temperature range for tapes and an improper alignment of the head can result in tapes you can read and write... but when the drive dies you can't read the tapes anywhere else.
Tapes still make sense above a certainly scale, but I think it's around 10PB before the real world costs of tapes, drives, robot, support agreements, extra capacity for inefficient incrementals/dedupe, etc.
The big win with tapes is it's much more feasible to rotate tapes offsite.
Tapes are also physically smaller, therfore their capacity per volume is better than for HDDs. Two LTO Ultrium catridges have about the same volume as a 3.5" HDDs, so you have 24 TB in the same space as a 14 TB HDD.
Moreover, the HDDs are much heavier. You can easily carry a suitcase with 20 tape cartridges, i.e. with 240 TB.
If you would carry a suitcase with 17 HDDs (238 TB), that would be around 14 kg (around 31 lbs). Possible but not at all comfortable.