I think the most likely failure modes involve removing and inserting the card, so I opt for strategies that minimize that. Zero insertions and removals is a good number.
In principle, I agree with you on this, but in practice, I remove the card to read into a computer. I shoot both stills and HD/UHD video, and have many GB's to transfer. The USB 2 connections on cameras are too slow, as is wi-fi transfer. The solution would be for cameras to start using USB 3.0, or better yet, USB-C (3.1) connectors. Recently I have started using 128 GB UHS-II U3 cards in some of my cameras, even though the camera does not have UHS-II internally (UHS-II is backward compatible with UHS-I). However, if I put the card into a UHS-II to USB 3.0 reader, I can get transfer rates in the range of 150 MB/s, which blows away USB 2 speeds.
If I were using CF cards, I think I would use USB direct connected to the camera, as the CF pins are too easy to bend.