Stereophile’s accelerometer tests are quite telling concerning this topic.
They have measured conventional MDF boxes like the Spendor A7 and Philharmonic BMR monitor that produce barely any resonance. Conversely, some of the special material Wilsons are shown to have at least one high amplitude resonance.
Based on my subjective experience, I believe a well-braced MDF cabinet, with sufficient wall thickness, is good enough for controlling any otherwise audible resonances. Often times, a speaker’s port resonance will be more audible than any of its cabinet vibrations. A good example is the Q Acoustics concept 50–barely any measured cabinet resonance, but it does have a port resonance at ≈160Hz that I found was surprisingly audible and distracting in my listening.
It seems like the well-braced aluminum cabinets from the likes of YG and Magico are the most consistently inert in Stereophile’s tests.

