I always envisioned an AI controlled camera, that always tries to keep all important aspects of the scene (marked by the developer, of course) in view, while still panning to get a different angle on things, when the player walks to different spots. Then the developer could set the camera to do certain developer-set choreography. But the main point here, is to make the camera good enough that the player would never have to move it.
This would be complex, though..
