[CT-3063] [Feature] state:modified doesn't detect changes to macros passed as variables

### Is this a new bug in dbt-core?

- [X] I believe this is a new bug in dbt-core
- [X] I have searched the existing issues, and I could not find an existing issue for this bug

### Current Behavior

```
# this is a model
{%- set configs = [
config_macro,
] -%}
{{- caller_macro(configs) -}}
```
_config_macro_ is passed as variable to be called by downstream macro

if _config_macro_ is changed, the state change is not detected by _state:modified_

if _caller_macro_ is changed, the state _IS_ detected by _state:modified_

### Expected Behavior

_state:modified_ should detect changes to all upstream macros.

### Steps To Reproduce

`dbt ls --select state:modified`

### Relevant log output

_No response_

### Environment

```markdown
- OS: 13.5 (22G74)
- Python: 3.10.12
- dbt: 1.6.1
```

### Which database adapter are you using with dbt?

snowflake

### Additional Context

https://github.com/FlipsideCrypto/livequery-models/blob/f15f5fc17535f295c772ff7b4af5725da23a659a/models/deploy/marketplace/quicknode/quicknode_utils__quicknode_utils.sql