General rule of thumb...if you want to know if something is functional or not, just look at race cars. How many 4 cylinder dedicated race cars (drag racing or road racing) have you seen with dual exhausts? If duals were the best (performance wise) for a turbo car, don't you think you'd see a LOT more street driven drag cars with them? All the big power Supras (may not be a 4cyl, but it is still an inline motor)/Evos/Skylines I've seen have been single exit exhaust. For V motors I understand the point for dual exhausts, but never for an inline motor.
Anyway, by looks alone it doesn't look too bad. A little too big for my taste, but I like an understated exhaust setup, personally...one that looks stock but flows better. The stock MS3 cat-back isn't too restrictive, so I think I'm going to stick with it to save some money, but again...that's just my personal preference. If you like it, go for it! Just don't try to argue that it's the best setup for performance gains.