Files that support Jinja expressions and/or custom Jinja macros

### Contributions

- [X] I have read the contribution docs, and understand what's expected of me.

### Link to the page on docs.getdbt.com requiring updates

Not sure which page(s) would be best for this. Maybe one of the Jinja pages? 🤷

### What part(s) of the page would you like to see updated?

[Internal Slack convo](https://dbt-labs.slack.com/archives/C0131TY7EEA/p1683301126883069)

It is is worth making more clear in our docs so people know which types of dbt files support each of the following:
- Generic [Jinja expressions, statements, and comments](https://docs.getdbt.com/docs/build/jinja-macros#jinja)
- dbt [built-in macros](https://docs.getdbt.com/reference/dbt-jinja-functions) (like `env_var`, etc)
- (Bring-your-own) [custom Jinja macros](https://docs.getdbt.com/docs/build/jinja-macros#macros)

Common types of dbt files:
- [`dbt_project.yml`](https://docs.getdbt.com/reference/dbt_project.yml)
- [`profiles.yml`](https://docs.getdbt.com/reference/profiles.yml)
- [`packages.yml`](https://docs.getdbt.com/docs/build/packages#how-do-i-add-a-package-to-my-project)
- [`selectors.yml`](https://docs.getdbt.com/reference/node-selection/yaml-selectors)
- [`_properties.yml`](https://docs.getdbt.com/reference/configs-and-properties#example)
- [*.sql](https://docs.getdbt.com/docs/build/sql-models) and [*.py](https://docs.getdbt.com/docs/build/python-models) files for different resource types (models, snapshots, etc)

### Additional information

_No response_