I had a Scoobysport exhaust on my Impreza and it sounded glorious
I think the sportier factory exhausts (STi/P1 etc.) are slightly louder than a std UK exhaust, but not much, certainly not worth spending money on (I don't know whether you'll get much of a power gain from them).