Elgg is a pretty good open source social networking application. I found an implementation of an older version here http://www.fanclubhelper.com. Looks like the site is still in development or something, but it shows the potential for Elgg. I especially like the Social Distortion and Cacti Widders pages!

Users can add their own band pages, start their own blogs, insert video and more. Pretty cool!