Yes, XLR is more resistant to noise. Shielding plays bigger role in RCA since XLR has inherent noise rejection by usage of twisted pair. Materials still plays role (capacitance, dielectric absorption, metal purity etc.)
On the other hand XLR often requires additional stage to "make" inverted signal. In electrically quiet place RCA can sound better IMHO (but I still like locking connectors). It is also application depended, as you stated. XLR has shield grounded on both ends creating possibility of ground loops in some systems. Also XLR is most likely more expensive - why to spend extra money if you cannot hear the difference?
On the other hand XLR often requires additional stage to "make" inverted signal. In electrically quiet place RCA can sound better IMHO (but I still like locking connectors). It is also application depended, as you stated. XLR has shield grounded on both ends creating possibility of ground loops in some systems. Also XLR is most likely more expensive - why to spend extra money if you cannot hear the difference?