Sony Vegas Movie Studio HD110 was recommended to me by Nick Howes.
It's very powerful and pretty intuitive to use, and it will walk you through everything until you get the hang of it.
I think I paid $50 for it.
You can try before you buy too.
http://www.sonycreativesoftware.com/moviestudio