The only part of this that is semi accurate is that SAS interface devices are a bit of a chore for the home user. I have an ATTO HBA in my Mac Pro 5,1 and it works like a charm with LTO-7 external drive. Otherwise, there are no format compatibility challenges; no stringent environmental issues. The 6 TB LTO-7 tapes are cheap and with LTFS, pretty easy to use - like drag and drop easy. I’m not sure what other issues you have encountered but if you have enough data to justify the investment, using tape in 2025 is quite straightforward.