If done right, social network sites are self-generating traffic and content machines. Your users create content which attract more users which create more content... you see where this can lead. Here's one guy's tutorial on how to set up a social networking site using Joomla:
http://net.tutsplus.com/tutorials/ot...-using-joomla/