This excellent article by Cyndy Green on her blog VideoJournalism discusses when to use and more often, when you shouldn’t use, camera and lens movement.

Zooming, panning, and tilting…
These are sometimes the most effective tools in the VJ’s shooting toolbox and should be the least used too. But all too often beginners can’t hold still and just let the action happen. They just HAVE to tweek things a bit – usually a bit too much. So if we’re able to make these moves, when should we and why shouldn’t we? – more