This Steam Controller mod uses vibration to guide the gamepad back to its charging dock on its own

Auto-Charge Tracker is available on GitHub, so you can try it out for yourself