I agree with pieterc, the transchip camera did work also for me, but beside the NDA there was also the little detail of the firmware to be uploaded to the module every time. Moreover, using their source code meant having to sacrifice quite some eprom, unless you wanted to rewrite the api in a more optimised way.
I checked quickly the ST one and seems that all is ready to go, in the pdf also the commands are well documented. Beside the funny footprint bga-like, this might be a killer camera module!
Ste