Here are few scenarios when adding a lock can come in handy:
Adding a higher lock that young children can't reach or open without adult supervision.
Sometimes the door only has one lock (on the doorknob) and you want to secure the entrance with another lock (deadbolt).
Give someone the ability to enter at certain hours and lock the door using a separate key.