For free software, WMM2 is what I recommend.
Mid-level Software I recommend:
High-level software I recommend:
Media Studio Pro
There are more useful info on the programs on the Software List link I gave you earlier, if you want to know more.
Also, browse/search through the Video Software Forum Section, and you'll be sure to find tons of threads of people asking for 'Software Recommendations'.