Do you buy Monster brand home theater cables? Do you own and love Bose products for the price you paid? If you do, buy DYNAMAT!
Seriously though, DYNAMAT works, but it's the most overpriced product in its class.
Cabin noise you hear in your car is from two main sources... audible noise from tires, wind, and your engine, and secondly from chassis vibrations that resonate into audible sound.
To eliminate the vibrations...butyl tar-based dynamat adds mass to the resonanting/vibrating sheetmetal it's applied to and absorbs the energy converting it into low level heat.
To eliminate engine, wind, and tire noise, you can add dynamat to the interior firewall, interior wheel wells, and doors which will be effective to a point... but even better would be to use dynamat in addition to a "barrier" type noise suppresor.
Read the stuff on b-quiet.com. They sell brown bread, which I bought 3 years ago and used on my doors and trunk, but I plan on saving even more money this spring when I buy their v-comp foam cell barrier material and use it with HOME DEPOT-bought "Peel n' Seal" tar-based roofing adhesive material (on my entire interior floor, firewall, and rear wheel wells), which on many car audio forums people have used which is nearly as effective as more expensive dynamat/brown bread.
The Peel n Seal is about 1/3 the price of brown bread per sq. foot, and Brown Bread is about 1/2 price of Dynamat. I'm puling those numbers out of my *** but if you do the shopping you'll see I'm not that far off.
I drive a '93 nissan 240sx hatchback.