This short guide is a quick rundown on how to set up a Linux system with the necessary drivers and tools to reliably use any HPE LTO tape drive with LTFS for home or semi-professional file archival purposes.
Quick recap for users hoping to use Windows:
There is no hope. The current state of affairs of LTO tape drive support on Windows 10 and up is so poor, that by the time you get it all working, it might no longer work effectively after a single reboot with yet another update of some kind. All in all, Microsoft has permanently broken the Windows CopyFile API for sequential access since 22H2, disabling updates is very difficult, Windows Defender interferes with file access, and Microsoft and OEM drivers for SAS/SCSI controllers are extremely outdated. Just don't do it.
Instead, as expected, we rely on open-source and *nix instead.