I’ve done both. The spray foam can be uncooperative sometimes. I prefer the pink stuff. I also would not use the rolls on the ceiling unless you have a couple sets of hands.

I like the foam for unusual surfaces. I spray foam behind my outlets even when I use the pink stuff. The pink stuff doesn’t even itch anymore.

Even if the pink stuff was (it’s not) less efficient… stack the difference in sats. Way out performs energy costs in my experience.