Sometimes - depends on where you live. But, at least in Ohio and Virginia (grew up in Ohio and work in Virginia), too much air into the exhaust system will cause the car to fail. A leak not only lets exhaust gas out, it also allows oxygen to enter the exhaust stream.
I have no data upon which to base this opinion, but it would seem to me that a hole in the exhaust system of an automobile would not pemit oxygen to enter the exhaust gas flow downstream since the tendency would be for the gAsses to exit through the fissure, thus displacing the air surrounding the outside of the pipe (which would be at a lower pressure).
I agree that a relatively small hole in the exhaust system would have more of a positive effect on an emissions test than a negative one. Of course, if that hole was also making more than the normal amount of exhaust noise, then you'd most likely fail the inspection on that basis.