Although bad video compression kills some of the magic here, you MUST SEE this incredible flight sequence by goffb rendered in Carrara 5.
I try to approach camera movements with a real life feeling – just try to imagine you are realy in the scene moving the camera. This means, that in real life your camera would be mounted to a vehicle for moving shots. And in this case needs to follow the physics of real life. So keep your camera movements dirty – add jerks and false movement to your camera moves.