Always Looking for Good Expanding Foam

I am always looking for good (better than decent) expanding foam. I use it around piping, for spaces where I think bugs could enter, along duct work (more to stop vibrations that anything else). This is a really good comparison - for a quick visual :)

But understanding the differences of when to use it vs. sealant is also good to know.