Avid released an update to Media Composer 4 today which makes Media Composer compatible with Mac OS 10.6, Snow Leopard.
While this seems like a minor update to increase compatibilty, I recommend checking out Macbreak's series of videos on "Automation in Snow Leopard" (I'm linking to the first in the series, see check the bottom of this post for the rest). The Avid update was released today so I doubt anyone's had an time to play with it, but this creates some interesting possiblities.
You can, for instance, set up a folder, and have everything dropped into that folder convert to a Quicktime for the web. Export a fast Same as Source Quicktime out of the Avid into this folder, and free up Media Composer to get back to work while Mac OS does the work of transcoding.
Or vice-versa. Maybe a producer sends you a Quicktime they want their editor to work with. Have a folder set up that converts everything in it to full-frame D1 and encodes it with the Avid codec, so you get a properly-resized Fast Import.
Alright, I've got to end this here, I'm getting all worked up just thinking about it.