You can't make a straight 6 engine sound like a V8, no matter what exhaust you fit.
Something like an Eisenmann is probably what you're after, not too loud or boy racerish, but lets you hear the engine a lot better than the stock exhaust. However they are not cheap!
As long as you have a resonated mid-pipe it won't drone at motorway speeds.