Your lead-in picture is a $2000 camcorder and you only cover free softrware and some of them just barely qualify as NLEs?
Pinnalce Studio HD ~$130 and user friendly. Lots of features if you dig a bit (RTFM) and several useful add-ons. Includes a nice DVD Burning setup with chapters and animated menus. Past versions have not been rock solid stable, but certainly useful. Scorefitter soundtrack software gives custome length royalty free music, but not as good as Smartsound.
Sony Vegas Studio ~$130 not the high end Vegas (~$500) but is comparable to Pinnacle. More stable. Fewer add-ons/plugins available, but plenty powerful for most advanced home users.
FCP X $299 - Forget all the initial screaming, FCP X is easy to use and more powerful than it gets credit for. Sure, it has that easy to use "iMovie Pro" interface. Is easy to use a drawback? Most of the power-user features are there, including a very handy multi-cam syncing set-up. Larry Jordan has some nice tutorials if you know how to use a search engine.
Those are the ones I know best in the sub $500 range. Above that you get Premier (why would you NLE in After Effects?), Sony Vegas Pro, NewTek SpeedEdit, Avid, and Edius.
Interesting story on the Pinnacle/Avid front. Pinnacle made home video software for years. MAde a lot of money and they bought Avid. Just this year, Pinnacle sold Pinnacle to Corel, but kept Avid and continue to develop it. This seems like an odd move unless they know something we don't.