I'd like this too, but I'm not sure how to do fault injection against an Amazon-controlled service.
You’d probably have to work directly with AWS on that one, either to get a custom harness in AWS, or to find out how they configure RDS replication.
the setup would prob ably be pgsql primary, aurora secondaries on diff zones and something changing cross-zone or cross-region vpc setting to try to break replication ? never tried that but was hurt by rds pure pgsql cross region replication in a network outage situation.
I believe RDS Postgres is probably the right answer for lots of applications, especially for those that already depend on AWS for baseline availability. I'd love to see if that holds up against a rigorous analysis.