Weird bug with imports in not related files

### Expected behavior

When I trigger a dbt run, dbt build or dbt compile from the UI, it does it and nothing else.

### Actual behavior

I just came across the weirdest issue I have seen with dbt power user (which I really enjoy btw!). I realised that if there is a file at the root of my workspace which is prefixed by `dbt_` and that has the following import : `from dbt_dry_run.cli import dry_run` the code in that file gets executed.
It should not be executed. (initially my file had a non working code and therefore any dbt command was failing).

### Steps To Reproduce

- create a python file at the root of the workspace prefixed by dbt_ . For example dbt_hello.py
- Add the following import: `from dbt_dry_run.cli import dry_run`
- add some code : `print(hello)`
- Run a dbt compile/build/run in any dbt project in that workspace
- Check the ouput

### Log output/Screenshots

13:42:30 Running with dbt=1.8.2
**hello!** <-- the line that is executed
13:42:31 Registered adapter: bigquery=1.8.1
13:42:31 Found 8 models, 4 sources, 496 macros
13:42:31
13:42:31 Concurrency: 1 threads (target='dev')
13:42:31 ...

### Operating System

macos version 14.6.1

### dbt version

1.8.2

### dbt Adapter

dbt-bigquery

### dbt Power User version

v0.45.0

### Are you willing to submit PR?

- [ ] Yes I am willing to submit a PR!