Reddog, sorry you had a bent pin problem. A lot of the time when we hear of those, it seems to be with inexpensive, "no-name" memory cards.
I change CF cards all the time... sometimes a dozen or more swaps a day. And I've been doing that for going on ten years. Never had a bent pin problem. But I use relatively high quality cards... Sandisk, Lexar, and a few Sony.
Cards are designed so that you can't insert them backwards or upside down. You'd really have to force it.
Sorry, but just I don't buy your (and John's) solution.... One big card that's never removed and a USB cable to download. There are a number of problems with that, too.
1. I couldn't buy a single card that's large enough. Some days I'll take upwards of 2000 RAW images with two cameras. The most I can recall was close to 5000 images, more than 200GB worth before editing.
2. I definitely don't want to put all my eggs in one basket. If a card fails or is lost, I'd rather it be a smaller card with only a portion of the day's shoot on it. Most of the cards I use are good for 250-300 RAW files each. So if a card ever failed or got lost or corrupted somehow, I'd lose no more than 10 or 15% of the day's work. Knock on wood, I've never lost a card. But I know other folks who have.
3. USB cable downloads are slow.
4. USB cable downloads rely upon the camera's batteries being charged up enough to finish the download, unless you also get an AC power supply kit for the camera and use it.
5. USB cable downloads can fail or be corrupted due to connectivity issues, a failed USB port or a failed USB cable. Both the ports and cables can and do wear out with extensive use and they fail a lot more often than memory cards and card readers.
6. To me the images on the card are the most important thing. The camera and memory cards are just tools in the process of getting those images and they do wear and get damaged over time. The sale of one image might easily pay for a $229 repair.
I'm sure I've swapped memory cards many thousands of times now. For almost four years, much of my work has been with a pair of 7Ds and fourteen memory cards I use in them, that have taken close to 200,000 images total... so something like 300+ card swaps per camera in that time.
I've screwed up with a memory card exactly once... pulling a card out too fast, while the camera was still writing to it, and corrupting about 1/3 of the images on it (that was an older camera that was slower writing, there's little risk of this occuring with recent camera models that write a lot faster). No harm done to the camera. No permanent harm to the memory card, either.... just corrupted some of the images on it.
I did have trouble with image transfers via a card reader once, too... a few images out of a large batch were corrupted. Figured out it was a bad USB hub and re-connected the card reader directly to the computer. No more hubs! Problem solved.
I now use a desktop that's got a built-in card reader (eSata connected, I think) and an Expresscard reader with my laptop. Both of these are far faster transfering than USB. The Expresscard is a cheap one and a little fiddly to align the card, but I'm careful and it works. I only use it when I absolutely must, on location.
I do use the USB cable, too... but only to set up and sync my cameras, and occasionally for tethered shooting. Not for downloading images.
Oh, and the reason it costs $229 for Canon to fix the bent pin is because they don't straighten it, they replace the entire CF socket and have to pretty extensively disassemble the camera to do that.
If I were you, I would very carefully inspect the memory card I was using when the pin got bent... I wouldn't be surprised if there were a fault with or an obstruction in one of the pin holes of the memory card.