Second this — Heroku pg is the main reason I've stayed with them, paying $$$/month to host my service. If Fly (or Render) can match the seamlessness of that experience, that'll be where I host next.
We're definitely thinking about a deeper integration here. As it stands you can absolutely connect a Crunchy Bridge instance to fly and we have folks that do just that, and it works for them.