Do they choose this, though? Or are they either renting (absolutely no choice) or not monied enough to upgrade their house in this way? Is this something that your average builder offers the average person building a home? (My parents didn't have that choice when building a house in the 90s)
So as long as you're in a place where common construction crews have regular experience building thermally insulated stud-framed walls, you'd at most have to look for an architect that has experience designing cross-tenant sound isolation who is otherwise a suitable choice for designing the kind of home you desire.
Their existing experience allows to get decent economics for the design workload of even your one-off non-catalogue customization. And considering there are few differences between sound isolation and thermal isolation (except that heat can also be stopped by IR-opaque foam rolling in for air pressure in the evacuated space between two foils (AFAIK that is much better at shielding heat flux than sound's pressure waves, due to the inherent concentration of air pressure into the stiff foam, as there is no gas pressure inside the pores to handle static air pressure forces, while heat conduction doesn't focus like it and heat radiation is interrupted by the opaque foam walls that act as "vacuum super insulation"[0]), and sound can also be stopped by thick heavy stone walls), the architect would at most spec slightly different insulation and likely somewhat different mounting brackets/pads for connecting the drywall to the frame.
The end result is no need for non-trivial engineering that a local architect should be able to satisfyingly do from experience, and a design that is just a little weird in overall layout/structure, instead of exceeding the construction crew's scope of experience in any particular detail.
I was told lowering they ceiling and creating an air gap is effective
At my last apartment I could literally hear my neighbors cough. Absolutely miserable. I wish there were some sort of measurable standard rating for noise transmittance through walls that landlords are obligated to disclose to potential renters.
Like rockwool: https://www.rockwool.com/north-america/products-and-applicat...
Eliminate all holes, and it just becomes a question of mass.