I have tried it in the past on a lot of cars and measured them on a rolling road.
Usually it gives you 0 (Zero) to 1 (One) bhp extra. Without any other changes to the engine pretty useless, except when the current cat is blocked.