There will definitely be a lot of jostling as Cassandra gets ahead here, and ScyllaDB there. Yes, we've talked about our plans to get to 1RT LWTs.

And you are totally correct to point out that there are needs for conservatism in people running at scale. Hence why we recently released making our Enterprise offering available as either a short term feature release or a long-term support release.

The MV issues have been hardened in ScyllaDB so the likelihood of them getting out of sync are minimized. And we're implementing Raft into the architecture to make them even more consistent with the base table. [Not available yet, but part of our roadmap.]