Hah, my requirements are very minimal right now. I would say that in the greater context that one of the important things for people using postgres would be plugin support for e.g. postgis and logical replication(which is not a builtin for postgres
https://2ndquadrant.com/en/resources/pglogical/).
Never having to worry about vacuuming manually would be pretty sweet, and having some level of access to the host to install e.g. vividcortex would be nice.
Not having to worry about pgbouncer would also be nice (though that means postgres pooling on your web hosts, sort of separate from the hosted postgres bit).
Also, I suppose obvious warnings when I'm near IO or storage limits would be swell