We had spray foam added under and over our old farmhouse we owned outside Atlanta. The one caveat is make sure the area being sprayed is sealed up tight. If the liquid phase being sprayed gets into somewhere you don't want it, it will expand in that space.
If you are going to have a pipe in an area, best practice is to not have the pipes roughed in at spraying, and then use a plastic type pipe in the place you want your permanent pipe. After the foam does its initial set you rotate the pipe left and right to loosen it from the foam to leave a cylindrical tunnel to run your permanent ones through. Works as well if you want to have a channel to run future wiring through, and, don't want to deal with chopping up foam to work on it.
If you are going to have a pipe in an area, best practice is to not have the pipes roughed in at spraying, and then use a plastic type pipe in the place you want your permanent pipe. After the foam does its initial set you rotate the pipe left and right to loosen it from the foam to leave a cylindrical tunnel to run your permanent ones through. Works as well if you want to have a channel to run future wiring through, and, don't want to deal with chopping up foam to work on it.