I have had dynamat installed above my headliner for almost two years and there has been no negative side affects.
As far as is being effective, I definitely noticed an improvement especially with road/wind noise. The roof is just sheet metal, with very little attached to it, much like the back of the cab, adding mass to it will certainly help things out.
-Ryan