gPhoto is a program and library framework that lets users download pictures from their digital cameras. The libgphoto2 library gives you access to hundreds of models of digital cameras on several platforms. GIT repo and Issue tracker lives at https://github.com/gphoto/ these days.
ZoneMinder is video and cctv surveillance and security application. It supports multiple video or IP cameras and a sophisticated motion detection system based around zones. Both live streams and historic events can be viewed via the web interface.
LinPHA is an easy to use, multilingual, flexible photo/image archive/album/gallery written in PHP. It uses a SQL database to store information about your pictures. It comes with a HTML based installer, so you don't need experience in setting up SQL
RAF converter is a C/Gtk# program that opens, optimizes (gamma,saturation,sharpness, whitebalance, noice etc) and converts RAF files (Raw image files from FujiFilm Finepix s5000/s7000 digicams). Everything is done via an intuitive graphical interface.