It's really sad. When this was introduced (With Lion I believe?) it was such a cool feature to demo to people that didn't have much exposure to Macs yet at that time. Just deleting and restoring a file on the Desktop with the "Space UI" and backups just being there and working without buying complicated backup software was a genuine peak macOS moment.
Now I'm barely using it as every few months I'm prompted to just delete the backup and start fresh because something corrupted.
Leopard, which means I've been using it for almost 20 years. The first ten were pretty good.
I have set up Time Machine backups for literally hundreds, if not thousands of people in a support role over many years and have hardly ever witnessed this happening. It's one thing to say you may have had to do this once or twice in a decade or the like, but every few months is ridiculous and speaks to some other underlying issue with your setup, like a quietly failing drive or bad cable, etc.
I'm not one of these 'it hasn't happened to me, ergo it's impossible people'. I completely think that many of the design elements of Tahoe are a horrendous regression versus even Sequoia, but I think asserting that Time Machine is completely broken in the shipping version of macOS is a bold statement that deserves a bit of pushback, even among the fire raging in a lot of other places in macOS!