Chessbase Light 2009
A stripped down version of Chessbase 10 with certain features disabled or removed. It is an update to the earlier Chessbase Light 2007 and much older Chessbase Light. Being based on what is arguably the leading commercial product, it has many excellent features and one of the smoothest and most attractive graphical user interfaces to tempt users to purchase the full flagship Chessbase program.
But there are significant limitations. Creation of new databases is disabled meaning only existing databases can be opened and even then they cannot be edited. Also many features are only easily applied to the first 32000 games of a database making working with larger databases clumsy or impractical. Internet chess is available only via the Playchess server. Finally there is no support for UCI chess engines which restricts the user to Chessbase associated chess engines.
Previously available on the Chessbase website but it has since been removed. You might find it somewhere on the internet with a little searching.
Arena
A chess GUI with the running of computer chess engine tournaments in mind. UCI support allows the use of a wide selection of chess engines. It can be used as an interface to the Free Internet Chess Server and Internet Chess Club although there are better interfaces for those internet chess servers. It's reported that Arena can be a bit buggy at times.
SCID vs. PC
This is a fork that is being updated pretty frequently based on the Shane's Chess Information Database (SCID) project . The visual presentation and user interface improvements have greatly increased the appeal of its fast if somewhat wonky database capabilities and ability to work with UCI chess engines and various chess servers.
Fritz 5.32
Old but good. Somewhat clunky interface for a commercial program but its unrestricted ability to manipulate both PGN and Chessbase files make it a standout among free programs that can work with chess databases. It can also run engine matches but was mainly designed to play games against. Cannot support UCI or newer engines though and may have some compatibility issues with newer computers. Internet play is not supported either.