"The reason I recommended the spray foam is from prior experience with a client some years ago.
He went with the stud/rockwool (great stuff roackwool as is the recyled denim product) in Wisconsin and subsequently had ground water and black mold issues. This was after he treated the concrete walls with a fungicide. With the proper open cell foam with fungistat inclusions his issues were finally resolved. Kind of a long way around..."
Which is why I stated that (closed cell) foam, which is vapor impermeable, had to be used against the concrete, and then a stud wall (filled with Rockwool, which is vapor permeable) erected in front of the foam (with an air gap between them).
I'm not a big fan of foam in general. Aside from the greenhouse gas issues, most, if not all, of them give off toxic fumes when exposed to flame. And they burn at around 750 degrees F, much less than the 1100 degree temperature of a typical house fire. They are also prone to insect infestation (at least when used on a building exterior). Neither of these deficits should be a problem on an interior basement wall with a layer of sheetrock sandwiching the foam (and fire stops above it) and foam is the only thing that can be used in that location. As to spray foam, there are additional issues in that it has to be applied very carefully - and often is not. Also it hides leaks and is difficult and messy to remove if necessary for repair or renovation. Foam boards are less of a problem in these ways.
I am a fan of Rockwool. I've used it in both residential and commercial, interior and exterior locations and the benefits include:
0% smoke production, 0% combustible. It simply melts - but at over 2100 degrees F. Mineral wool, such as Rockwool or Thermafiber, is required in the interior walls of high rises in many locations because of its ability to retard fire spread.
Sheds water, doesn't support mold growth.
Deters insects and rodents (unlike foam which carpenter ants and other insects love, and fiberglass, which rodents love).
Has a reasonably high R value of 4.2/inch.
Doesn't degrade, unlike fiberglass which compresses over time. I've found fiberglass batts in walls and ceilings of 50-60 year old homes that were completely flat. I think fiberglass is pretty useless as insulation due to the above facts and because it melts at a low temperature (1000 degrees or so) and falls apart when wet.
Sorry for the long rant.