I’m not recommending anything, just asking a question. Tape is not suitable for random access, the latency is huge (find the tape, load the tape, wait, search for what you want, select what you want, wait for the restore). However, once what you’re looking for is found, tape is as fast as a single drive – 120+MB/sec transfer rate. Even with an autoloader, which are expensive, it’s still going to involve quite some delay (minutes, not seconds). So don’t get tape as a random access device. Use it for backup and archive: stuff you know you need to keep, or you don’t know for sure you can purge.
LTO isn’t really comparable to DAT. DLT supplanted DAT. And LTO has supplanted DLT.
Time Machine is designed to backup/restore an OS, your applications, and some user data. It’s not really designed for your use case. The backupd consumes a lot of CPU, it does it every hour. If you’re willing to hack the preferences file to change the backup timing to something rational like noon and 6pm – or just 6pm – that’s better that this crazy daemon going off every hour and sucking the life out of system resources while you’re working. I’m not sure what use an hourly backup in this workflow would be, but if it’s working for you, fine.
However, don’t bet the bank that these Time Machine backups are going to last very long. I somewhat regularly have them totally implode on me – and that’s just backing up my laptop with an SSD in it. Pretty much once or twice a year I expect to reformat the Time Machine destination volume and start it from scratch. So it’s most definitely not a reliable archive. It’s a fairly reliable short term backup for an OS, apps, app prefs, and some local user files. For massive video files I’d use something else for your “nearline” (faster than tape) backup to drives: Carbon Copy Cloner or Super Duper, maybe someone here has advice on that. CCC is rsync based (it has its own current build of upstream rsync in the app, it doesn’t use the ancient version OS X ships with although you could use that too, or build a newer one from Macports), and Super Super is ditto based. CCC can leverage an rsync checksumming feature to confirm the source and destination are the same, although this is slow. The checksums aren’t stored anywhere as far as I know, it’s just used to independently confirm/deny the copy’s success.