Urban myth, no doubt. In reality any drink drugged enough to incapacitate some burglars would also be strong enough to kill some of them. In the States, such a trap would be illegal, as would a deadfall or shotgun rigged to "get" an intruder without the owner's being there, and would result in a charge of murder against the homeowner regardless of the burglar's illegal intent and trespass.