So, I made it myself: a camera mount for the Raspberry Pi that you can easily mount onto any standard tripod.
Step 1: Create the 3D Model
I imported the enclosure face into 123D Design, then added a simple tripod bottom for it. Yay Creative Commons!
The tripod hole is 5mm, which I will later tap with a tap-and-die kit.
Step 2: 3D Print It
What I like about the VeroClear is that you can see the camera power to make sure the camera is indeed working.
If want to be a spy-cam look, you may want to go for black ABS to obstruct the light and also be sleek.
Step 3: Tap the Hole
The threads you want to tap for are 1/4-20.
If you've tapped holes before, this is a cinch. If not, check out this Instructable — you won't need any cutting fluid since you're 3D printing in some sort of plastic or resin. The tapping process is super-quick and can be done in your hand.
Step 4: Epoxy the Back Face Onto the Camera
There are other ways, such as:
* a snap-fit design: more work on the 3D modeling side and eventually the material (especially since I'm using resin in my case) will wear out.
* put screws in it: a lot of work and time, but probably the most optimal solution
* use a silicon adhesive or something less strong: my feeling is if you're going to use an adhesive, use one that really works.