Different uppipe brands will do pretty much nothing to the exhaust tone.
As for the Invidia CBE, there are a few of them. They range from OE look / somewhat quiet, to fartcan / obnoxious. As for the N1, there's a reason that style is so common in the FS section; if you go this route, do yourself a favor and save some $$ buying used so you don't take as much of a hit when you get tired of the drone.
Internet advice of "What exhaust?" is pretty much useless other than giving you ideas to consider.
There are four considerations when buying an exhaust:
1) Style: OE vs Fartcan
2) Volume: close to OE, medium, loud
3) 2.5" vs 3"
Figure what you're looking for in an exhaust, then hit up a few Subaru meets in your area. Get a feel for the exhaust in-person (video clips are useless except for a vague idea). See if the owners will give you a ride in the car, since that's where you'll be hearing it.
If you want to answer those four criteria, along with what car you have, people can give you some help on what exhausts may fit the bill.