Avid has one of the most straightforward editing workflows in the industry. If you are using Sony MXF based cameras and exporting to MXF it can be one of the simplest options and the program puts the focus on making solid editing decisions.
There's no fluff to Avid. Or not much, at least. It tries to do one thing and do it well.
Unfortunately Avid has had a hard time keeping up with a changing industry. It's file handling is stuck back in the early 2000's. It's overly complicated and picky as far as what it will link to and import. There shouldn't even be the deliniation between importing and linking.
Relinking files can be a nightmare to the point of ruining a project should the wrong things get moved or renamed. It should not be that complicated. The Avid Media files folder is equally as unecessary and problematic. It files up just like the Adobe cache folder but unlike premiere if deleted with have catasrophic effects on your editing project.
On the subject of effects... the interface is clunky and what you can do with it is limited. The last straw for Avid was when I was editing a music video and spending 2 hours on an effect that I knew I could do in Premiere in under 5 minutes.
The mode switching is also overly complicated. I should be able to make a splice or do colour correction without having to switch 'modes' and have the UI change. It makes the editing experience very disjointed.
Product registration is also overly agressive and not user friendly. There's way too much codes and verifying. I should just be able to login once and get the software without being bothered again.
Don't overcommit to avid. It used to be the industry standard but I don't know how much longer that will be true.
Straightforward editing workflow for traditional broadcast or film applications.