I work for a US VFX company. We mostly use tapes - they're fine as long as you don't need to pull data off them. Most of ours were backed up with Veeam which is in the process of screwing over all tape customers now. New backups are being done with Archiware. We've also started using AWS Deep Glacier which is roughly $1 per TB a month without egress. This is for any archives. If people are still working on stuff here and there, we use storinators to host that data. Hot tier is all flash.

Make sure Enterprises use Enterprise setups, else you'll end up with data loss. Personal or homelabs are whatever but ensure you're setup correctly for anything business related.