[Feature] finer grain of location selection in dbt init

### Is this your first time submitting a feature request?

- [x] I have read the [expectations for open source contributors](https://docs.getdbt.com/docs/contributing/oss-expectations)
- [x] I have searched the existing issues, and I could not find an existing issue for this feature
- [x] I am requesting a straightforward extension of existing dbt functionality, rather than a Big Idea better suited to a discussion

### Describe the feature

Found the original issue but that issue was archived on old repo, original issue here: https://github.com/dbt-labs/dbt-bigquery/issues/668

When we run dbt init to setup a profile

There is only two option in Desired location option

While it is not clear to first-time user what the location value here take effect, user is APAC region feels biased about not able to select their home region.

And evenmore, since in my case I have select bigquery as the adapter, it is intuitive that dbt can let user to select GCP region code as location input here, such as [45] asia-east2-b.

I expect there should be a full list of gcp zone to select during dbt init profile setup wizard.

### Describe alternatives you've considered

one way is to remove this location selection step during dbt init, if the location isn't critial in profile. Meanwhile, as an optional settings here, we provide guideline on how to mannually set it afterwards and where it will be used.

another way, if gcp zone is too detailed to list out, then region-grain is also acceptable like europe-west2.

personally I would like there to be a free text option as a third option

### Who will this benefit?

dbt init user, especially help if they start with dbt core.

### Are you interested in contributing this feature?

Yes, I can code it up

### Anything else?

_No response_