Hi YidDannyK,
Spray foam is an excellent product but does have its limitations, we are spray foam applicators and do cavity wall injection. Im not on here trying to sell you a product but can help you decide if its right or wrong for your property. You will need a survey which any good company will do for you free of charge. Spray foam when injected will fill all the gaps, its injected with a much smaller hole pattern than beads of fibre and during the process we inspect the filling process using a borescope. It is superior in the fact that it bonds the inner and outer wall together, where wall tie failure has occurred the foam combats this problem. It will totally seal your property and a great vapour barrier.
The below is not my product or my website (somebody will have to say something)
Have a read about the product here .
http://www.isothane.com/pdf/Technitherm ... tSheet.pdf they also have a video to watch the process.
The cost of foam is greater than any other wall insulation, but in my eyes used the the right property its far superior. It allows smaller cavities to be filled, often anything less than 50mm and the other companies will not touch it.
With regards to ventilation you will find that your house will already be ventilated, windows, doors, loft insulation all give plenty of ventilation to your property.
With the foam you will get a seamless thermal barrier so no air leakage will occur. The R value is about 6 per inch depending on what foam is used and the U value can come down to about 0.3 depending on your wall structure. People always write about spray foam will cause problems but im yet to see any in my years of applying it, never has anyone showed me a picture with a defect caused by spray foam.
I hope this is of some help with your choice.
Regards