It is so hard to know what something is going to sound like from the clips and what people say. I swapped in a 3-inch SS CBE that was purported to be quiet, but was hella loud and that droned at 3500 rpm. I replaced that with the Borla 2.25-inch diameter CBE and it is comparatively silent (but with a nice tone on WOT and really from 3000 rpm and up).
I'm keeping the stock cat and adding only relatively minor adjustments on the intake end (finally getting installed Monday finally). I don't really get the "3-inch diameter exhausts are quieter" argument. My anecdotal experience was not like that. I suppose it all comes down to the design, materials, and manufacturing (plus any other stuff going on in the intake-combustion-exhaust stream in front of the CBE). It all happens together.
In any event, I would (with 20/20 hindsight) do all the stuff in front of the CBE first and see how that sounds. That is not what I did. But I would now. If that is close to what you like, I would look to the smaller diameter exhausts (2.25 to 2.5). You probably can't go wrong with Cobb or mountune, but I'd bet both are going to be louder than the Borla/FRPP setup. I suspect the Borla/FRPP team developed their product(s) with overall sound containment in mind. My Borla has a nice sound. It burbles slightly on idle, is very stock under 2800 rpm, provides nice feedback on strong acceleration at 3000+ rpm, AND (here's the kicker for me) has NO DRONE at the dreaded 3500 rpm range. That's a win to me, but I'm only going MP215, mountune FMIC, and mountune induction hose. That's it on the intake side.
wwuchris: I see you are local to the Seattle area. Perhaps we can get some Fiesta ST folks together for a burger G2G sometime in the spring. Or a track day! I have some Focus buddies that I could collar as well. Take care and have fun.