Exactly, if cloud cannot be trusted I might as well buy a synology nas and drop at a family member's home.
However, I'm guessing that--if you're anything like me--you get lazy about refreshing it and, if something happens, you realize it's been a year since you did a fresh backup.
A cloud provider backup (as opposed to sync) is a good belt-and-suspenders cheap insurance backstop to local backups that you hopefully never need.
I have local Time Machine and Synology NAS but I also pay Backblaze a nominal amount. Companies were paying Iron Mountain large sums of money before there was a cloud.
Though online backups have their own risks (ransomware).