Flickr Gallery For Your Website?

Can anyone recommend a good looking gallery (either a standalone or one for Joomla) which will display your photosets on Flickr on your own website as a gallery?

I've found a couple but quite frankly they look naff! I'm after something that looks good and that will automatically update itself each time I upload a photo to Flickr.

I'm using something for Joomla at the moment that does the job but it's a bit on the basic side, I just want something a little more 'flashy' (although not necessarily powered by Flash).

Main features I need are:

1. Ability to display Photosets as individual galleries
2. Ability to choose size of large photo to be displayed i.e. Medium, Large or Original
3. Large photo to appear in something like a lightbox

Other features which would be nice but not essential

1. Ability to show or hide comments
2. Ability to show or hide EXIF
3. Ability to play a slideshow

Any ideas?