A 12" arm will not resonate more simply because it's longer, it certainly will resonate at a lower frequency. The amount of resonance is far more a function of materials and design. Also a longer arm is easier to set up because it has lower tracing error, and thus minor misalignments are less noticeable, the same way that minor VTA changes are less noticeable. Typically a long arm will have higher mass and so favor lower compliance e.g. moving coil cartridges. And all of those things together enable high performance stylus designs like Shibata, Fineline, Microline, MicroRidge, et al to perform optimally.
Personally, I find that the 10-11" length to be the best compromise. Like the VPI JMW Memorial 10.5. With its 3D printed epoxy arm it is well damped, long enough to enjoy lower tracing and VTA errors, and I don't ind it being a unipivot - they do not bind or have bearing chatter, maintenance is easy, and swapping arms takes about 30 seconds. OK, the second arm tube isn't cheap. But it sounds great, and puts the fear of God into people who shouldn't be using it anyway, e.g. party guests.