The reason for me to choose "the best cable" is to avoid common noob errors and to shield against all the noise I have in my room, refrigiator, cheap SMPS, flickering lights and so on. On the other hand do I want to use the RG400 as standard workhorse cables between my gear, so it is maybe not to great if the cable is a stiff piece of iron or thick like a garden hose. :-)
Noise usually gets into sensitive circuits through means other than coaxial cable, but double shielding is necessary in certain applications. For instance when testing receiver sensitivity, the test signal tends to leak out of the patch cable attached to the source directly into the receiver bypassing any attenuation stages; double shielded cable helps considerably with this.
I like RG-400 because it is more flexible than RG-142, the double shielding makes it more mechanically rugged at the connectors, the Teflon dielectric makes it easy to solder, and the solid Teflon dielectric makes it resistant to contamination which would affect loss. In practice however, RG-142 is just as good and a little easier to work with except for being stiffer. I have had troubles in the past with plain RG-58 and especially RG-8X cables failing or becoming high loss.
RG-316 is the Teflon version of 0.1 inch diameter RG-174 so also very useful when you need to solder coaxial cable directly into your circuit but need something thinner. It is not double shielded but I have some RG-316 patch cables for their extra flexibility.
LMR cables use a braid over aluminum foil shield so are really only suitable for fixed applications where flexing is minimized.