Hmm, not an easy one to answer really! There's such a choice covering a range of budgets. However, you suggest you wanted something close to free. With that in mind, you wouldn't be prepared to spend money on the likes of Adobe Premiere and I suggest you try out Pure Motion Edit Studio.
http://www.puremotion.com/