As a novice, I don't have much to add from the above comments, which are all very usefull. I'd just like to say that camera movement should be motivated by feeling. Most times the audience doesn't consiously register the fact that the camera is moving (if it's done right). When the movement is used well, the intended emotion for the scene is stronger. If you watch Stanley Kubrick's Paths of Glory focus on the scene when he is walking through the formation of troops. The camera is pulling back and Kirk is walking toward the camera. The audience can see his face, which shows very little emotion. Kubrick's shot choice, pulling the camera back, creates the emotion of the scene. If you imagine the camera in a stationary position, with Kirk walking toward the camera, all the magic of the moment would be lost. That's the best that I can explain it. It's all about the emotion. When something hits you emotioinally, a moment that just hits you hard, go back and analyze it. See how it's done. Practice.
Also, the movement should not be noticed by the audience (fellow filmmakers excluded, since they would see it anyway.) If you shoot a scene with movement, you should be able to see if the movement is too jarring. If it is, it looks cheesy. That's all there is to it. in my opinion. Examples of this might be found in a Michael Bay film.
Good luck
Rick