For most digital camera users, software like the already mentioned free FastStone Image Viewer or free Picasa from Google is all they'll ever need. The bundled Windows programs are not sophisticated enough, and most software that comes bundled with cameras is dreadful!!!

http://www.faststone.org/FSViewerDetail.htm
http://picasa.google.com/