There is also talk of more gain with balanced. As I understand it the extra 6dB is a lower noise floor rather than extra gain.
That’s not correct. The extra 6 dB is the doubling of the signal amplitude due to having 2 signal wires with opposite polarity. Here’s an online calculator. Put in 1V as the start, 2 V at the end and it will come out to 6. This is the same ratio you get when going from RCA to XLR.
https://aetechron.com/calculator-Volt2dB.shtml
As others have noted, with short runs away from noise sources the noise is the same.
So, in terms of the signal to noise ratio (S/N) the N isn’t reduced, but the S is increased.