We've been running with vanilla EB + ECS for months and haven't seen this at all.
From an outside perspective, it sounds like the primary issue you referenced here (the agent disconnecting) could have been due to a mismatch in configuration between the agent and docker, or maybe just a permissions issue. IIRC, the ECS agent tries to clean up containers every few hours so perhaps not being configured correctly caused it to get stuck?
I'm wondering if Elastic Beanstalk is hiding this from us in some way. Or maybe just has a workaround built in?
Depending on how many RIs you have, maybe our custom shapes, much lower prices with per-minute billing and sustained usage discounts, and BigQuery vs RedShift you'd still come out ahead. You could always try your hand at reselling your RIs on the "market".
Would you rather run pgsql by hand or K8s? (And yes, I don't want to make you choose, that's just the current state of the world).
Disclosure: I work on Compute Engine, so of course we want your business.