Good point P Monty, the Pi can trigger a 'normal' camera.
Many cameras allow a remote shutter switch control to activate the camera, and a hotshoe for a flash.
Pi GPIO could drive a transistor to short the remote shutter contact. The camera will take care of flash synchronisation.
You can also use a camera with long shutter time or Bulb setting to capture multiple strobe flashes, in dark conditions. That can be used to freeze motion as in waterdrop photos.
See this blog post:
http://www.raspberrypi.org/water-droplet-photography/