Hey 97Gtguy
You stock legacy manifold should look like this :
or similar the resonator and mufflers quiet it down a lot.
If you reuse your stock manifold and rid the system of the noise dampening components you might get some rumble out out it. I rode past a beat up 94 Legacy L wagon on I-66 that sounded just like a WRX (I could see the the tail pipe had rusted off)
If you go with the OBX/TWE EL knock offs you wont have any rumble just honda like sound.