Since we've been looking at photo sites, here's another addition to the list:
PictureTrail. This site allows you to upload pics from your computer in order to create custom slideshows with a variety of transition and frame effects. To use it on your blog or website, simply upload the images you want and decide on your look. Once you've added all the "extras" you desire, PT will generate an embed code that you can paste on your target page.