Yes the autopilot does a great job usually (with or without lights), but for certain approaches (eg CAT 2) we must "sight" some runway lights otherwise it is a go-around.
It's not as simple as selecting the lights ON or OFF at minima to determine if I can see better.