I know exactly what sound you are talking about....
My front passenger door has been doing it for months now...but the lock would still work. Just recently I've noticed that when unlocking all the doors, that door sometimes doesn't unlock.....think we have the same problem.