Postgres RDS limits you to only the extensions they make available to you. That alone can be enough to turn off some people.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_...