Power locks snapping on and off: sounds like a machine gun going off.

[EAD15]

Very high probability that you need a driver door lock actuator since that is the master for the car. Cycling locks are a common symptom and it's a part that many others (myself included) have replaced. It's a pain to access just because of it's position inside the door, but not a particularly difficult repair otherwise nor an expensive part. Part number should be 96252707