One out of the three people that I have seen sprayed was not affected by it. I was at a nightclub and some bouncers sprayed a guy that was out of control (not inside the club). The spray only enraged him more. I'm sure alcohol and/or drugs had something to do with it.
Point is, it don't always work the way you want it to.