Well I'm a gear head, have owned 4, 6, and 8 cylinder vehicles, most with exhaust kits and have heard many others in my life.
I will tell you that I think the f-sport will do exactly what you want. It will make it sporty without being cumbersome or annoying.
Just keep in mind that this is a V6 engine. No, it by no means sounds like your typical civic with an exhaust. However, it by no means has the "raw" sound of a V8 mustang either. Instead, it almost has a kinda pur to it, but when you open it up it does get a little raspy/throaty....again in comparison to american v8 engines in trucks/mustangs/etc. If I were comparing it to a inline-4 I would say that it's definitely deeper without the high-pitch motorcycle-like sound that you typically hear coming from a civic with exhaust.
I've only actually followed my car once or twice from the outside, but I would say the following
In this video, I think the sound is slightly deeper than what I've heard when the car is accelerating: http://www.youtube.com/watch?v=Mb_d5iuSvU8
In this video, I think the sound is a slightly more higher pitched than I remember from my car (note at the very end it's hitting the rev limiter which is why it sounds like that): http://www.youtube.com/watch?v=97h3w1hhjvw
So, if you don't mind something that falls between those two, you should be good to go.
I can't comment on the braaaap noise ...I'm not quite sure what you're referring to, especially since you referenced it with regard to midpipe changes, which I don't really read about since it's never been something I was interested in. My suggestion would maybe be to search the forum for midpipe, and see what people say with regard to how it changes the sound, and use that as a reference for how it might change.
Also, it looks really sweet, as it kinda slopes upward slightly to give a nice look under the rear bumper (although maybe that's due to my lowering springs????), vs the stock exhaust which not only looks ugly but also appears to go straight out. I know it sounds stupid, but when you see it you'll know what I'm talking about. Looking at the car from the rear 3/4 view forward looks great.