My approach is to use managed DB instance and to share it between projects: create dbs inside the same instance. In this way the cost of instance is split between all the projects. Also this service is on my todo list to try for this use case https://neon.tech