Max's Physical Camera is the best general-purpose camera type to use with Cycles for perspective renders. This plugin supports many features of the Physical Camera including depth-of-field and motion blur.
Targeted and Free Camera
Both the targeted and free camera in Max are fully supported by this plugin. Either of these is the best type to use when doing an orthographic render.
Cycles Panoramic Camera
This plugin includes a special camera for panoramic renders: Panoramic Camera