One of the technical writing mailing lists I’m on posted a link to a site with freeware/open source software listings. This site, NGO-In-a-Box, provides a list of open source or freeware software geared towards a specific purpose: audio/video editing, desktop publishing, etc.
The Audio/Video site looks excellent. Unfortunately the desktop publishing portion appears to be suffering from PHP and MySQL errors.