I think much depends on your room setup & size, number of plants, size of plants and what bulb one is running.
Overall 600w tend to the wattage of choice just because it's a happy medium between 1kw & 400w. It's the best bang for the buck if you could only buy 1 ballast set. But it is possible to provide better coverage & penetration using multiple ballasts.
I used to run several rooms. I had my 6kw room (6 - 1000w ballasts), 1.2kw room (2 - 600w) and another 1.2kw room (3 - 400w). Obviously the 1000watter room yielded the most but also costs the most to run. The other two rooms - well it depended on what strains I was running. If it was a tall sativa - the 600w room did better than the 400w, probably due to being about to penetrate further down into the plant yet still be hung high. 400w can be pulled in closer to the plant than the 600w but not by much. I like how the plants turn out using the Philips HPS-Retro CMH bulb but the largest wattage it comes out in is the 400w.