The car is stock. I want something with a good sound but not too loud. Cherry Bomb, Magaflow..... i just can decide.

borla is pretty good ecpessialy for performance or sound

TRY AEM tune able muffler and sense this car is an older Acura they don't make anymore

I would try PACESETTER muffler.com
these mufflers have there own sound >> especially if your car is the in-line 5 cylinder I think is <<<
Pacesetter muffler will give it that classic Europen or Italy sports car sound like a >twin cam v12 SJ type S JAGUAR<<.
and it will not be annoyingly loud but you'll get the respect on the street for having a muffler sound that is not heard often with all of these Imports and their Japanese muffler systems that are common not.

I've got Magnaflow on my 1994 Legend, but your vigor does have one less cylinder so not sure how good it would sound.

if you want a quiet exhaust i'd go with..tanabe racing development. Quiet and doesn't sacrifice performance.

Usually the quieter the exhaust the less flow and in most cases less flow means less power.