These are some examples that you can accomplish with using CN Photos Module.

Download links for the module supported in Joomla 1.5/1.6/1.7 for free here!