To recommend an optimum thickness of the foam and the foam/fiber R-ratios the local climate matters. Where are you?
3" of closed cell foam is about R18 or more, and expensive R at that. For basement walls it's cheaper & greener to use some thickness of EPS or polyiso (sealed with can-foam at the edges & seams) trapped to the foundation with a fiber-insulated studwall. Rock wool is somewhat preferable to cellulose in sub-grade applications if there's even a REMOTE chance of ground moisture seepage or minor flooding, since the rock wool can dry quickly, and celluose can't, but it depends on the site conditions/setup/climate.
The foam/fiber ratio needed for basement & crawlspace walls by climate zone are roughly the prescriptive levels for above grade walls found in the IRC, by climate zone:
http://publicecodes.cyberregs.com/icod/irc/2012/icod_irc_2012_7_sec002_par025.htm
Assume R15 max fiber-R for 2x4 framing, R23 max fiber-R for 2x6 framing.
The D.O.E. climate zones referenced in the IRC documents are as delineated in this map:
