Agree 100%. Would be awesome if you could have RDS with FDW connected to a Redshift instance. (don't know if that's possible given the version of Postgres upon which Redshift is based)
What is more exciting is you can leverage Redshift MPP architecture with this method.