Just saw this over at SparkFun, the FlyCamOne: http://www.sparkfun.com/products/11171
It’s controllable (probably?) via a single GPIO, and saves image and video data onto an onboard SD card, which can be accessed in mass storage mode over USB (potentially from a USBizi board, such as Panda II).
Neat hardware, and not extremely expensive, especially for what you get (480p video and stills).