If you have a rigid neck, that doesn't use up the string's energy from it's own motion, and doesn't send the energy somewhere else, doesn't that mean that the string's energy is maximized? If you don't lose vibrational energy through the neck or body, it means the only things opposing the string's vibration are things like the internal friction of the string, friction at the end points, air resistance (which results in the audible sound waves), the magnetic field of the pickup (which creates the electrical signal) and gravity.
So I would say, a rigid neck and a stable neck joint are what allows for maximum sustain. And I would expect the neck's length, mass, construction, and wood types to affect it's resonant properties as much as the joint type, unless the joint is not very stable and allows the neck to flex at that point.