Fully balanced design, which is normally found on only some very high end equipment (such as Ayre, BAT, and Atmasphere, to name a few examples) provides a separate channel from input to output for both the "hot" (pin 2) signal, and the "cold" (pin 3) signal.
Don't know about the others but Atmasphere uses differential circuits, which even though balanced are not completely separate.
Modifying an SE cable by putting XLR connectors on it or using RCA to XLR adapters does not turn it into a balanced cable. It is still SE.
I think the salient points are:
1. if it is designed to operate as balanced use it that way
2. XLR connectors are better than RCAs but if you are using SE equipment you are stuck with RCAs unless you DIY.
3. In an electrically noisy studio with a myriad of equipment balanced has distinct advantages and that is why pro gear is balanced, but your house is not a studio.
4. With the large amount of excellent SE gear it is hard to argue that balanced is inherently better in a home environment even though those that make it and use it would disagree. You will hear the argument that I tried my balanced amp both ways and balanced sounded better so balanced is better. If it was designed from the ground up to be balanced it should sound better when operated that way, but it doesn't prove anything about balanced vs. SE.