Rockwool was recommended when I built my free standing sauna last year, so I gave it a shot.. it’s supposedly mold resistant in a humid environment, rodent resistant, and a good product to control noise.
I can’t vouch for the rodent resistance (yet), or the mold resistance, but the building is very quiet.
The Rockwool was probably 50-100% more expensive, which didn’t really amount to much for such a small building.
There’s no integral moisture barrier, which adds a step to the installation process.
There’s stuff has poor structural integrity, and it’s heavy. I had problems with it disintegrating and collapsing under its own weight when insulating the ceiling. Once it falls, it breaks apart and has to be disguarded.
I wouldn’t use it on a ceiling again because of that. I had no issues on the walls, though.
My opinion: not worth it except if noise reduction is an important objective, like a house near a highway or airport.