What do you mean blackbox? It has explain analyze, it has rich query meta info, it has a web interface to query stats. You even know on what hardware it runs. Genuinely not sure what's blackbox about Redshift.
We had a cluster last week spend 7 hours in a DB health 'unknown' state. Response from AWS? Spin up a new cluster from snapshot.
I suggest you check out BigQuery. Redshift is not truly "fully managed", and it's not really HA/Durable, as your experience indicates.
It's a hosted service. You don't have access to the source code.