Basically it comes down to what you're trying to do; so what are you trying to do?
Once again, let's look at vehicular insulating materials:
Dyanmat (and all the other butyl products) is a sound
deadener. This means when it's properly applied it will absorb the micro-vibrations in the metal that amplify sound. Think of it as a damper... It's a great underlayment to what ever else you use to insulate. My favorites these days are KilMat and Siless, both around 1.60 a sq. ft. (compare to the roofing crap mentioned above at 7 bucks!) and you can buy them in small packages thus eliminating waste. (compared to the roofing at a min. 7' roll). Also, could not find how thick the roofing stuff is, I would doubt it's the 80mil thickness of the automotive product.
Next you would have sound
absorbers. My favorite is 3M's Thinsulate (yes, same stuff in your jacket) . It comes in two thicknesses for automotive use; 1" and 2". Obviously, the thicker the better. Not only does it do a good job at absorbing sound, it also has great thermal insulating properties. Something to think about when the sun is beating down or there's snow on your roof. It attaches fast and permanently with 3M's spray 90 adhesive. And it's totally hydrophobic, so condensation won't be absorbed like it can be in carpet. There are other materials like sheep's wool and recycled denim if you're going for a "green" feel. They work well from what I hear...
Then there are sound barriers, the best being lead but it's expensive and really heavy. The stuff I prefer is called Mass Loaded Vinyl or MLV. It has a density similar to lead but less expensive and easier to work with. But, both of these materials need to be decoupled from the metal, and you would use a Closed Cell Foam, or CCF, for that. If you don't, then the sound just transfers from the metal (firewall) to the material and into your environment. MLV makes a great firewall sound barrier, but it needs to cover it completely to be very effective, which means cutting to fit and taping all of the seams. You can buy it with a layer of CCF pre-bonded to one side to make th installation easier. And again, goes up permanently with 3M 90. Though I wouldn't bother with it on your roof.
Last but not least are the hybrids that include Noico's "Red" (a CCF material) and Lizard Skin, a spray-able coating. The first is an interesting product, I have some but haven't used it yet. It's a type of CCF that claims to be both a deadener and absorber and thermal barrier. OK.... but is it good at all 3? Dunno.
Lizard Skin gets mixed reviews. Some folks are all in and will tell you it's better than sex, but I've paid less for good sex; Lizard Skin ain't cheap! I would like to try it myself if I had the underside and the interior of my Wagon body sandblasted, surface prep is key for that stuff and it needs to be applied to as much surface as possible for max efficiency. Yer on yer own...
FWIW, in my wagon I'm using KilMat where ever I can stick it on (and yes, it sticks permanently to clean surfaces, including the inside of your roof, but get and use a ROLLER!) and then Thinsulate over that. I'm using MLV on the floors and I'll try the Noico Red on the inside of the firewall and underside of the cowl. And when you tap the body panels, you get a nice dull thud.
As far as home materials are concerened, sure you can cheap out and use roofing material, carpet, wood, pink fiberglass, whatever... It WILL do something! And it's better than nothing. But it might just soak up some water and get smelly or moldy or ? Then getting that sex will probaly be off the table after the first ride.
My moto is "buy once, cry once". Go for the high priced call girl or the skank at the stop sign; your choice