you'll need to reposition your cylinders so they oppose each other and operate at a different pulse cycle, if you want the MS3 to sound like a WRX or STi.
(peep)
No seriously, it won't sound EXACTLY like the Subie's not matter what you do, because the engine configuration is different. They are boxer engines, not inline. Due to that, they behave differently, and have a different sound. Just like V6's and Inline 6's sound different. I had a V4 motorcycle, which had a TOTALLY different sound then the I-4's of the motorcycle world.
The issue with the exhaust:
WRX's and STi's ARE turbo, like our MS3 (and a bunch of other 4 cyl turbo machines), and with a large diameter, tuned exhaust system, the sound will be deep, growly, and free of the bumble bee fart can sound that most of the import world seems to sound like. You see, turbos by their very nature are great mufflers. They smooth out the exhaust pulses and use that energy to spin their other side - the intake turbine. So, what you get out of a turbo car is a vastly different sound. With regard to what your co-worker was saying - I'm not 100% sure, other then the fact that, yes indeed, the WRX you heard is turbocharged, and will sound different then the standard Impreza.
You want your car to sound deeper, and more growly though? Wait and see what comes out for the MS3. The stock exhaust ain't bad, but the aftermarket can improve it. It is almost impossible to go too big on a turbo's exhaust setup.