I think some shots in the Berman era are pretty excellent. I generally like his professionalism, which presides over any tendencies over excess style. I am going to find more examples, but one shot I just watch, though it may be from a film, is really really awesome. In First Contac
t, after the girl in engineering is taken by the Borg, we cut to Picard in the silo, reading through some specs, but he knows something is wrong. Same shot, Troi asks him what's wrong. Same shot, he starts walking down the hall and we realize that, even as Troi follows him, so are Data and Riker in the background. That the camera follows him makes the scene seems very urgent, and when the viewer realizes that Riker is in the shot as well, suddenly we know the story itself will soon change.