Camera is now fully working , Stills and Video, apps like Skype, instagram, google talk are working with camera. This will be add to nightlies sometime in future. This preview is built with -
Goo.im Downloads - Downloading cm-9-20120926-UNOFFICIAL-cam-preview3-tenderloin.zip
has been updated
Goo.im Downloads - Downloading update-cm9-tenderloin-camera-preview5.zip
more info here
UNOFFICIAL CM9 with working camera - HP Touchpad Android Development - RootzWiki
and here
[ROM] UNOFFICIAL CM9 with working camera - xda-developers