[Feature] Need a feature to provide the names for the on-run-end and on-run-start hooks

### 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

Hi Team,

If we have multiple macro calls in on-run-end hooks, the items are listed as {project_name}-on-run-end-0, {project_name}-on-run-end-1, {project_name}-on-run-end-2 etc,,. And this is the current behavior.

It could be better if we have the facility to rename the hooks such as {project_name}-on-run-end-{my_macro_name}.

Example:
jaffle_shop-on-run-end-grant_permissions_macro
jaffle_shop-on-run-end-log_dbt_results

### Describe alternatives you've considered

_No response_

### Who will this benefit?

dbt Cloud & Core users

### Are you interested in contributing this feature?

_No response_

### Anything else?

_No response_