I understand a lot of mainstream movie production these days uses Linux, which suggests there's no shortage of good software. The question is, what features do you want?
Personally I like Kdenlive
. I've only used it for fairly basic stuff, like combining short videos into a DVD with a menu and intro, but it has a good range of features and is easy to use.