[SPARK-3634] [PySpark] User's module should take precedence over system modules

Python modules added through addPyFile should take precedence over system modules.

This patch put the path for user added module in the front of sys.path (just after '').
Aha, I see that we _do_ add `root_dir` to the path in `worker.py`.