My ex husband took Antabuse and it was a miserable failure. It was not the drug's fault in any way though. While the medication itself did what it was supposed to, which was make him violently sick if he touched alcohol, he just got around it by stopping taking it.

If however someone took it as they were meant to be taking it, I think it'd be a good deterrent.