> which means package resolution can't look first in a local subdir

Sure it can, it's just a matter of examining where it's being run from.

I wrote python-wool to load packages from a venv if it finds one.

https://github.com/fragmede/python-wool

Yep. That comes under the category of "not default". Although now you've pointed it out I'll probably be using it.