[Feature]: Allow CLI to scan workspace packages for Capacitor plugins

### Description

Enable development of app + plugin monorepos by allowing commands like `cap sync` find plugins inside workspace packages

### Platforms

- [ ] iOS
- [ ] Android
- [ ] Web

### Request or proposed solution

Right now the capacitor CLI can only detect plugins inside `node_modules/` which makes developing a plugin and an app side by side cumbersome, especially if the two packages are in a monorepo together. It would be nice if the cli could use to root `package.json` to detect if any workspace packages are Capacitor plugins and include their relevant files when running commands like `cap sync`

### Alternatives

_No response_

### Additional Information

I actually already have a PR up for this but it never got looked at. Its out of date now but if theres interest from the maintainers to actually add this feature I could take care getting it up to date. https://github.com/ionic-team/capacitor/pull/7723