AFAIK tuning an exhaust is about creating standing waves in it, i.e. making it just as long as the wave of sound/pressure that travels through it. That means of course that the effect only works at one given engine speed, as the engine regime will determine the frequency and thus the wavelength of exhaust.
But I also seem to have heard that exhaust tuning is only worth its while on two-stroke engines.