You could edit in after effects but it would be a painful experience, its more for certain segements where you need some certain effects, like logos, simple animations, adding certain filters etc.But for an overall editor you want Premiere Pro or Sony Vegas.Hollywood uses mainly Avid but thats more to do with just what the staple program is, the others can do everything Avid can do (Cameron edited Avatar on Avid).If you have a Mac then you can try Final Cut Pro.My personal fav is Vegas for simplicity though now Premiere Pro has realtime cuda effects Im torn between the two.