I feel your pain. Check out poetry if you haven’t seen it already as a modern alternative to pip.