PCWorld lists various useful software available to download for free. Not necessarily open source software, but definitely free. Features a lot of software I favour: Abiword for word processing, Audacity for recording and mixing mp3 files, Avast antivirus, iTunes media player, Trillian for internet messaging and Thunderbird. Hundreds more on the site.
Thanks Exdua, via digg.