My wife got one to try and automate away the vacuuming. We went through the same thing, and it still needs to be babysit anyways. For the sheer amount of time and frustration of basically all robot vacuums, it has been easier to just get a nice Kenmore upright bagged vacuum and do it yourself anyways (and the results are basically always way nicer).
We've had the Chinese dreame with valetudo (so fully disconnected from the cloud), it works honestly very well. Doesn't get stuck, avoids my son's toys rather effectively and just works. I run it when we leave home.
There's honestly no reason why roomba didn't make something equivalent to the dreame, they could have competed with the Chinese manufacturers on feature and by allowing users to easily disconnect from the cloud. They didn't because the company was completely mismanaged and their products barely evolved.
I'm pretty optimistic about biped robots for this. Either you buy or lease one and a cleaning service teleoperates it, or subscribe to a cleaning service that drops it off and teleoperates for a few hours a week. Suppose it could even walk itself to the next customer if close enough.
If a wheeled low-profile vacuum that stays in a room is too hard to deliver, surely we can fix it by making it walk around and grasp a vacuum cleaner and walk between houses.