Better management of a working folder with a lot of projects (over 20)

### Describe the feature

Hello,

I am working with a lot of DBT projects (we use local package).

The extension starts one Python script for each dbt_project found.
Each takes around 100MB of RAM.
And the end, the extension takes around 4GB of RAM on my laptop (without VSCode processes and other extensions) and it is too much.

A good feature, for people who use a lot of different DBT projects, would be to auto-detect project.yaml files.
Then, have the choice to run only one selected project instead of all.

Best regards,

### Describe alternatives you've considered

Remove projects from workspace, but I have dependencies between a lot of packages.

### Who will benefit?

Lots of companies using different packages for each flow (let developer be independent and accelerate DBT)

### Are you willing to submit PR?

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