> Having a code update, or some orchestration issue from your infrastructure provider be potential points of major outages are huge and unnecessary risks.

I trust any of the big cloud providers to do these things more reliably than I can. In particular, if I'm going to replicate a database across data centers within a region (availability zones as the big cloud providers call them), I'm quite sure that a managed database service will be more reliable than my own hand-configured cluster.