It may depend on your needs and learning curve ability.
I personnaly use Adobe Premier 6.5, but from what I heard Premier Pro has much more enhancement and an all in one package for a good price. Learning curve for this is quite high
Another one that I used to use is Pinnacle Studio 9, has eisier to use interface for the novice, and easier on the pocket but lesser functionality than Premier. One problem with this software is that you will have to pay for additional functions (i.e. additional title fonts, transitions,etc). Good luck
