unless you need the airspeed side of Avid, it pretty much sucks. It's light years behind Final cut and Premiere Pro in interface and workflow design, mainly because since Avid the industry standard direct-to-air capable NLE, they don't have to worry too much about competition.
Most of the guys I talk to in the TV industry agree that if Premiere or Final Cut ever decides to make a full DTA server-based version of their programs, Avid will get creamed. Plus, at $5,000 for a basic turnkey, and $20,000 for an adrenaline-equipped system, the $900 Premiere Pro makes a whole lot more sense for the average non-professional user. He's making a musical slide show here, not Star Wars 7