I don't trust Time Machine any more. Years ago I wrote some shell scripts that help me mostly automate my complete system setup (with brew and friends). From time to time, I wipe my entire system and restore it with these scripts. Sometimes I have to adjust them, but mostly, they work without changes.
For my data backups, I use restic. Big advantage is, that I can read my backups even when I don't have a macOS system present (e.g. my only macOS system had a hardware issue and my Time Machine Backup was pretty much useless until I got a new one).
I know, this solution is not for everybody, but Time Machine corrupted my backups more than 5 times now and it feels so slow compared to restic, that I don't even think about retrying it after a new macOS release any more - even if my solution is a bit more work to do.
For my data backups, I use restic. Big advantage is, that I can read my backups even when I don't have a macOS system present (e.g. my only macOS system had a hardware issue and my Time Machine Backup was pretty much useless until I got a new one).
I know, this solution is not for everybody, but Time Machine corrupted my backups more than 5 times now and it feels so slow compared to restic, that I don't even think about retrying it after a new macOS release any more - even if my solution is a bit more work to do.