If your waterproof jacket is a laminate (gore/event etc) and is genuinely leaking, then it’s time to say goodbye to it as the membrane has degraded to some extent and no amount of spray or wash-in will fix the problem.
If on the other hand, you have been wearing your jacket in warmish, humid conditions, the chances are you got wet from a mixture of stuff coming in through the holes (neck/wrist) and your own juices from perspiration. Reproofing with a spray or wash-in (more accurately – replacing the water repellent finish) will help water bead off the jacket and should help with the apparent breathability of the jacket (i.e. more of your sweat gets out)
I use grangers wash-in on my goretex jacket and trouser and found it lasted longer than Nikwax. The new stuff doesn’t need heat treating either, which is handy. I use the spray on stuff on my paramo too and haven’t found any problems.