I think your head will stay hurting for quite awhile. Why ? Because we all have a favorite, and therefore you're gonna get different answers
Me, I tried some, and I like Screenblast Movie Studio 3 the best. Mostly because I prefer working with their timeline syste; instead of Storyboard like the others mostly do. Plus it has more then enough filter, FX, transitions, and so on, even filming on a blue blackground (or any color) and changing the background afterwards. I mean, for me, it does all I need it to do, and it's only the "little brother" of Vegas, the big package.
On the other hand, if you ever need to upgrade, Vegas works with the same interface, so there's no new learning curve, and you only pay an upgrade price for Vegas also. So editing program wise, my 2 cents...
But analog input ?? Just remember. garbage in = garbage out. I mean, you can't make analog look digital just because you edit it digitaly en export it digitaly (to DVD or VCD), the source you'll be working with is and stays analog, point to consider.
If you have older footage and it happens to be in 8 or Hi8, consider buying for instance the Sony TRV460, it records digitally and can play your older analog tapes and export it digitally (works as an A/D converter for other formats too).
Other people will give you other programs to consider, but for most of them, there are trial downloads, so I would suggest, download and try and see what you like best.
For the Screenblast, the download is here : (also the manual in PDF)