If you want simple to use: Ulead.com has both amateur and pro versions of software. I have also used software made by Pinnacle and found it pretty easy to use.
If you want a big "chart of options" check out http://video-editing-software-review.toptenreviews.com - Amazon usually has most of the software or you can buy from the company sites (I think all of the ones reviewed are under $100)
