i have been involved in quite a few code escrow agreements but none that were actually used. i'd be curious to hear any stories about cases where that did happen.
in my experience it has just been a way to help business decision makers credibly claim they are managing risk when buying from a startup