I don't think they are actually used, but some special forces, like British commando, train with the crossbow for night ops and hostage situations, like on air planes.
But yes, the crossbow is great to give a non range, and especially a general non combatant, something to do without wasting...