This feels like the sort of the where it works great 90% of the time, but as soon as you want to do something more complicated/nontrivial it doesn’t handle it p

This feels like the sort of the where it works great 90% of the time, but as soon as you want to do something more complicated/nontrivial it doesn’t handle it properly and is impossible to debug/improve since you are using an opaque solution. At least with scaling replicas or having a dumb cache layer it’s easy to understand the system.