module: remove require('.') with NODE_PATH compatibilty

This basically reverts #1363 and removes the hack in place for the unintended use case of require('.') used in conjunction with NODE_PATH.

I'd like to give users a few months to accustom to the deprecation, so it might not be a candidate for 2.0.0, but rather 3.0.0.