fix(exec): look in workspace and root for bin entries

[wraithgar]

Closes: #7379

[npm-cli-bot]

no statistically significant performance changes detected

timing results

app-large	clean	lock-only	cache-only	modules-only	no-lock	no-cache	no-modules	no-clean	show-version	run-script	cache-only peer-deps	no-clean audit
npm@latest	28.170 ±0.85	10.533 ±0.05	11.656 ±0.03	1.540 ±0.01	1.522 ±0.00	1.251 ±0.00	8.208 ±0.02	1.261 ±0.01	0.136 ±0.00	0.161 ±0.00	14.735 ±0.23	2.102 ±0.04
#7569	28.087 ±0.84	10.496 ±0.05	11.885 ±0.02	1.541 ±0.02	1.545 ±0.01	1.274 ±0.00	8.320 ±0.03	1.300 ±0.01	0.139 ±0.00	0.166 ±0.00	14.597 ±0.12	2.086 ±0.00

app-medium	clean	lock-only	cache-only	modules-only	no-lock	no-cache	no-modules	no-clean	show-version	run-script	cache-only peer-deps	no-clean audit
npm@latest	21.671 ±0.06	7.872 ±0.04	8.877 ±0.01	1.492 ±0.01	1.501 ±0.00	1.381 ±0.01	5.735 ±0.04	1.294 ±0.01	0.136 ±0.00	0.165 ±0.00	9.827 ±0.18	1.964 ±0.01
#7569	21.478 ±0.31	8.011 ±0.03	8.928 ±0.03	1.526 ±0.00	1.531 ±0.01	1.422 ±0.01	5.844 ±0.04	1.315 ±0.02	0.138 ±0.00	0.164 ±0.00	9.829 ±0.02	1.991 ±0.01

[reggi]

LTGM