The cat goes crazy with just one spray, but...
In our case, she gets a bit aggressive. It's better if she plays alone with the sprayed object; if I get involved, she scratches wildly, even though that's not her usual behaviour. Her interest lasts about ten minutes, but it helps her burn off some energy.