For the cellulose and rigid I wouldn't worry about the foaming of penetrations unless they are big enough to have a blow out in the living space.
For the fiberglass and rigid, I think foaming the perimeter to seal off any leaks would be good, but probably nothing other than that.
Good luck out there.
Housewrap as your blowing barrier makes a lot of sense, though it's like wall papering a ceiling getting it in place!!
I dunno about the foam board. Where I come from (cold climate) that might work with unfaced EPS board. But If you use foil-faced Thermax, that leaves you with a vapor retarder on the cold side of the assembly, doesn't it?? Great idea in an A/C-dominant climate. But that's a really bad idea here in Wisconsin.