Now I'm barely using it as every few months I'm prompted to just delete the backup and start fresh because something corrupted.
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!
To be clear, I'm not saying it's Tahoe related, it has been there for many years.
Tons of people complain about this. I suspect it's some subtle bug with sparse bundles and SMB.
I don’t know what these engineers are doing at Apple, but it surely isn’t making the ecosystem better, they’re just chasing hypes and shinny useless UI changes.