As part of their Sweetbox II Kickstarter, France-based Grasping Hand are offering the “ScorPi” which is a pose-able arm for the Raspberry Pi camera module. It plugs in to the composite video port and then attaches to the camera via one of its mounting holes. It costs £11 delivered (which I guess isn’t bad for a just-launched product) as a pledge to the Kickstarter. I’ve asked if you can get it separately and await a response. This looks like a good way of just holding the camera without too much messing about. Read more/get the ScorPi here