Scylla has "tunable" consistency[1][2][3], so it's possible to get consistency without too much of a performance hit, and still be resilient to some failures.
[1]: https://www.scylladb.com/glossary/eventual-consistency/
[2]: https://docs.scylladb.com/stable/cql/consistency.html
[3]: https://docs.scylladb.com/stable/cql/consistency-calculator....