If you have a Windows machine, absolutely.
With a native maximum resolution of 1600x1200 you can shoot in almost 1080p HD (I shoot at 1600x900 and downsize it to 720p HD). It has computer-controlled focus which means you don't have to touch the webcam to turn a focus ring in order to focus correctly. It has full manual controls you can use to get awesome picture quality (provided you have some desk lamps). It's small and there are numerous LEGO rigs designed by members it fits in perfectly so that it won't move around. It has a pretty long cable so that you can move it around a lot. It is also reported that the QuickCam 9000 is able to peel your bananas and make you a sandwich.
I'd say that the QuickCam 9000 is for both beginners and experienced/skilled brickfilmers. There are some who use a digital camera to shoot their brickfilms with (you should note that as good as the QC9k is as a webcam, even low-end digital cameras will have a better camera sensor), but digital cameras are a whole different and much more complicated area.
In short, for brickfilming on a PC/Windows machine the QuickCam 9000 is probably the best webcam on the market out there.