XLR are worth it for the positive locking connection they offer.
No pets, no children under 36, 1 wife, and my mother, I have never even heard that one of my friend's RCA plugs ever came loose, much less my own.
I have run 100 ft long snakes on professional use in clubs and concerts, 100% in those applications, RCA's would come loose.
In my home, they are hooked up one time and inspected for looseness, fraying, whatever, annually.
I have also never had a grounding issue.
Although many of my friends have (& we have spent a lot of time finding and fixing them)
& it's not like I only have a few pieces of gear hooked up:
2 higher end TT's, 2 Reel to Reels, 2 older higher end cassette decks, an AM/FM tuner, 2 SONY CDR machines, 1 modified (for region free) oPPo 205 UDP, all running into 2 APT/Holman Preamps, which run into 3 NAD 2200 amps (1 bridged mono L channel, 1 bridged mono R channel for each Dahlquist 905 & 1 running stereo at 2 OHM's into a pair of custom bass cabs.
Maybe I am doing something wrong, as I have never had an issue with an RCA connector coming loose. I know some people that have but, knowing them & their families, I am not surprised that it happens to them.
I have had some that were loose from the get/go but I immediately discarded them.