Don't go much on that selection to be honest. I have used many of the packages in that link, and they're either very difficult to get to grips with, or just poorly suited to editing (although very powerful for some things, for instance virtualdub is excellent for converting codecs).
I see they mention Lightworks, which is incredibly flexible, but getting it to work is like trying to knit fog, and I simply don't need this level of flexibility.
As an amateur level movie maker, all I require is the ability to accurately edit clips to trim away the chaff, apply simple fades and/or a lap dissolve and apply some basic titles. All the rest of the gizmos that come with editing packages I ignore.
the worst aspects of video production are the lack of standardization between formats. When consumer level digital video appeared in the mid to late nineties, all the manufacturers got together and agreed on a common standard, which became known as the DV codec. This simplified things enormously, then after a few years HD formats started to trickle in, but they diverted from this standard, using the newer Mpeg 2 (DVD) codec. With the advent of card based cameras things got more complicated still with the introduction of Mpeg 4 codecs.
Small wonder then that consumers get rather bamboozled by it all.