A correctly flown RA will create 500ft separation from the intruder, the idea being it doesn’t create an RA for the next aircraft. This of course assumes both started in level flight, if an intruder aircraft climbs or descends through the hold it will inevitably cause a cascade.
That’s why in a manually flown RA the training is to stay just outside the red, and in TCAS 7.1 version two introduced the “level off, level off” command. Auto TCAS will do the same. If you went massively into the green on a manual RA you stand a good chance of causing problems for someone else.