You can have transactional causal consistency with an AP system. Combined with CRDTs it’s very powerful.

You also have mixed (“just right”) consistency systems and techniques to introduce and optimise the use of runtime coordination where necessary.

For example see https://electric-sql.com/docs/reference/consistency