Avid is a great NLE, probably the most complete and powerfull to date.
But IMO, it depends a lot on each one business situation. The thing with Avid is that it is the editor for real professional editors, I mean people who are editing 9-10 hours a day everyday. Then Avid shines.
But if you do not practise regularly, it's very easy to forget it. (in that senses it's very much like Smoke).
I think that for multitask people, indy or small pros, that do all their things, included the shooting alone or in a reduced team, Avid is overkill and could be more a problem than a solution.
You really have to edit all the time to make profit of Avid.
For middle, big structures, it's another story, they don't have this prob because they can put people on the editing task.
So I think that for small structures, or simply people who can't-want to enter in a serious learning curve, there are easiest options being good options.
Now, it's true that for a relatively ambicious studio, with external editing houses in mind, Avid would be a great choice, but people should know first that it's not going to be a Premiere Pro or a Vegas learning curve.
Media Composer is a much more serious tool to master.
It is so true that there is a sort of pride within Avid editors because they know that none week-end editors are using it. It's pro only.
Having using it for some months now, I can tell that there is a good reason to go Avid, but there also could be bad reasons in some cases. It's great on comlicated stuff, colaborative workflow, lots of volume, file management, high-end editing techniques that require skilled operator...it's really bad on instant editing with easy intuitive interface that our gran'ma could do while cooking.
There are some advanced functions in the timeline for ex that are really suitable for working fast with flexibility and precision, but they require the guy real knowledge or at least training. In the right hands it could be a time saver, but if the person does not know what he's doing, it could f...d and ruin the editing tracks in the instant without you noticing it at first (so no necessarly will be possible comand-Z)...the "what the hell is that?..." will resonate. (same with Edius)
But I do think that Avid, even not perfect, is bringing me a real plus in my workflow and measurable in terms of time-money (they are the same) and capabilities.