SPTA - if power is your thing, you're barking up the wrong tree (dog reference!). The Flowmaster cat-back, and all similar single-exhaust cat-backs are going to produce the same amount of HP/TQ gains (give or take a smidge). There are very minimal gains to be had switching to a true dual-exhaust, and that would be at the sacrafice of a flat torque curve, louder (too loud?) exhaust, and lots of custom fabrication expense.
The restriction in the exhaust would be the catalytic converters (all 4 of them) and especially the stock exhaust manifolds. Removing/replacing the 'cat's' might yield a few ponies, but at the expense of becoming a gross polluter (sp?). Replaing the exhaust manifolds with something like the FMS or TorqueMonsters headers should show some signifigant gains, but you might have fittment and installation and reliability issues.
But let's think about this realisticly... The X isn't a race car, and the engine isn't a high RPM, high HP motor. Do you need an exhaust that is designed to flow 2x the amount you'll ever have?
I like my Flowmaster exhaust because it was a simple install, and the tone is noticable withOUT being annoying or intrusive. It has just enough tone for my 'better-half' to notice it, but not be annoyed by it. Sure, I might have gained a couple of HP, but ANYTHING will flow better than the stock exahust. I bought it because I like it, and maybe it will pay for itself by increasing my MPG.
If you really would like to do dual exahust, you should also look into headers, replacing the catalytic converters, and possibly re-camming your engine to take advantage of the high-RPM horsepower available. The more (and faster) air flows through your engine, the more power you'll make. But at what point does it become unlivable for day-to-day use?
My 2 cents...
-B