Re: Foam seems best, from my reading
TomD
I suppose it depends how good you want it to be. I have 3.5 inch wall, and they have vinyl siding, plywood, the stud bay which is filled with bats, and 1/2 inch drywall. Unlike insulating for heat. Your neighbours wall construction also counts. I run some big machines, my wall is about 3 feet from his. His house has a garage right next to my shop, but the second floor over it is his bedroom, he is mildly deaf, and never complains. I do not run machines normally past 10, and never after 12. He goes to bed early.
What shouldn't be underestimated is the noise of hammering. I would rather hear the occasional hum of a planer, than sporadic dovetail hammering. That is part of the reason I use a urethane mallet. The peak noise of hammering is pretty high, it is just very short duration. Apparently full out nail hammering is around 22 cal rifle levels, above the threshold of ear damage, but very short in duration. Bad combo for irritating the neighbours.
As to your question. The best sound damper when I was building was considered to be z strips for the drywall. These are metal strips that have a Z shape. One flange is fastened to the studs, and the other stands well proud of the wall to receive the drywall. This will subtract from you workspace a little, and I would also want to check the impact on racks, though I would think there would be some workarounds there. The idea of these strips is that sound transmission is less a mater of insulation than providing a solid highway for the sound to connect through.