OK so the lock cylinder is fine but the lock actuator isn't hitting where it is supposed to hit to lock/unlock. Take off door panel and see what is happening inside door would be my next suggestion. It shouldn't be working like that.