Things I have observed
Sharing Bruce's experience with Rockwool, been around a long time, that in itself is an endorsement. Any so so product in that vein tends to fall by the wayside as newer, better, higher preforming products come out.
A friend did some work on his basement shop to abate the sounds going up, he just used Rockwool and his Wife was very pleased with the result so he stopped there. He did his ceiling, had planned to also do the walls thinking the sound would follow up them, and get to the house above. In the end he never did stage 2.
On my shop I have standard insulation in the 2x4 walls R 15, and R 10 wallboard outside under the siding, and R 60 of blown in fiberglass in the ceiling. I also have the luxury of an detached building on several acres of land, with closest neighbors house at 100 yards. I can work 24/7 and nobody ever hears machines running. For that matter the closest neighbors are also the youngest, and frequently come in late. Seeing the lights on in the shop Jason called me to let me know.. I didn't hear the phone between machinery running, and hearing protection. I did note it when I got done a few minutes later, and called him back. I asked if he just got in, and he said yeah. So he was outside, and still didn't hear anything. Not sure there if it's distance, or just standard insulation numbers for a building today?