It makes a huge difference. As for "where" that is debatable. What do you want it for? If it is to quiet the cab, put it everywhere basically. If you want to quiet rattles, I just ran a strip on the inside of the door panel.
I used Peel and Seal. Not as good for sure, but it works well enough for me.