Depends on your requirements. Something lowest common denominator like LTO2 is still useful, cheap, reliable and the drives are also cheap and reliable.

You can always feed your LTO2 tape into a LTOx drive and get the data back.

Obviously you have to be fairly patient, but for my use case (once a week on my third tier of backup) it's good and gives peace of mind that I can put in a fireproof safe.

Primary backups are still on the cloud though - S3 Glacier is a good option.

By LTOx, you mean at most LTO4 right? I thought LTO drives could read at most 2 generations prior. Also, you need to get to LTO5 to get useful capacity (~1.5GB/tape), LTO2 is limited to 200GB + whatever you can get with compression.

I've been keeping an eye on tapes for literally a decade or more, but for my personal backups hard drives get enough bigger every year that I'm comfortable with (for now) a pair of 8TB usb drives with secondary local backups which I swap between plugged in at home and powered down in my locked desk drawer at work every Monday. I've got a while to go yet before I'm worried about capacity there, and 12TB drives are already available, and will easily be in the right budget soft spot for me when I need them.