Doesn't have to be loud (or look flashy), I have ff and branches and it makes less noise than the standard, you just need to go to a decent place to get it done. I just told them to put in some decent back boxes because I hate noise and I only put a normal looking stainless steel exhaust tip, unless you open up the engine you wouldn't think anything is different (or perhaps the exhaust tip but it's not flashy just different).
On N/A car it can help a bit, Fuel usage decreases, power increases and if you put in stainless steel type you don't have to worry about getting holes in the exhaust down the line (rust), unless you are an idiot that drives over boulders or something.