According to Mike Holmes spray foam is one of the best insulation products on the market.  He seems to apply it frequently on his show, especially for cold basements and rooms above un-insulated garage roofs.

If you’re looking for more information, this frequently asked questions is a good place to start.

I’m thinking about spraying my garage.  Has anyone else done this?