More on topic though, while there may not be a "simple" or trustworthy solution using built-in encryption on cameras or SD cards, it should be possible to create a (small, or "prototype sized but usable") device to sit in the middle of the electrical connections of the SD slot on any camera, and a normal SD card. The device would transparently encrypt video footage or pictures sent to the card. Would be an interesting side project.
I've used the Beaglebone's USB client and host ports, along with the Linux USB gadget drivers and LUKS, to do something similar to transparently encrypt USB sticks, it wasn't particularly fast (8-9MB/s) but it was usable :)
[1] http://en.wikipedia.org/wiki/Secure_Digital#DRM_copy-protect...