> In my apartment, my deadbolt was so sticky that it was hard to turn even with the door half open. Two spritzes (keyhole and the bolt) with WD-40 classic, and it moved easily, and continued to turn easily for the remaining 6 months in my time there. Could lubricant-X have done a "better" job? Maybe, not that it mattered in practice.
It was likely the solvent properties of WD-40 that helped. It dissolved the old, tacky lubricant or rust and left you with a cleaner lock. For a six month fix on a rental, that is probably fine. For a long term fix on a house you own, it may be worth using one of a plethora of lubricants designed for that specific use case (including a more specific variant of WD-40 that is designed for locks and leave behind a dry lubricant when it evaporates.)
> Because now there's something that can also unstick your lock, but with an even lower coefficient of friction?
WD-40 is decent at removing rust, but not great at repelling water and thus preventing rust.
There are a lot of things that go into picking the right lubricant for a specific application. It isn't just "which lubricant is slipperiest?".
WD-40 is indeed a lubricant, but much of the benefits of using it are due to its solvent properties and people often don't understand that applying it in the wrong circumstances can lead to removing the correct lubricant and result in less lubrication.