Sierra’s take: From the manufacturing side, we often see the most back-and-forth happen when the stack-up is developed too late in the design process. Material availability, finished thickness, impedance requirements, copper weights, dielectric thicknesses, via structures, and the fab house’s capabilities all affect one another.
One thing we always recommend: involve your fabricator before you start routing, especially for controlled impedance, HDI, high-speed, or unusual material requirements. A stack-up that looks perfect on paper may need adjustments to actually be manufacturable and changing it after routing can create a lot more work.