pgBouncer - multiple servers with same username but different password
There is a good workaround at the link in your question.
Another thing you can try is to use auth_user and auth_query with pgBouncer so that it fetches the password from the respective database. I am not sure if that works or if pgBouncer caches the password for each user.