There are lots of really good camera movement shots that help the story forwards in the masters' films. Some good recent ones to check out are Altman, Spielberg, Cuaron, Zemeckis, Scorcese, even Josh Whedon, with the Steadicam intro of the Serenity and its crew in Serenity for example.
Hitchcock and Welles did a lot of great ones two. Unfortunately, it seems that nowadays, less and less people understand the purpose of moving the camera and just do it for show.