And yes, you can delete all the photo at the same time using organizer, or you can use the API to write your own delete method.
For people with large collections of their memories, I think it's more common. That's why Snapjoy launched with duplicate detection as part of their MVP. My site (OurDoings) got compliments from a new user on several features, but duplicate detection was apparently the only feature that was capslock-worthy:
duplicate detection. EXCELLENT! Not encountered elsewhere and what a difference it makes, it means that people can dump their stuff even though they havent quite optimised/tagged/cleaned up their local stuff. It detected both duplicates in the file sets I sent (it happens with multiple computers, synchronisation, and multiple aborted organisation efforts) and when i sent files already uploaded. Removes a lot of work :)
If you're using Flickr as an event display solution, it's quite easily done.
I have two pro accounts with Flickr, specifically so I can shoot and present events while still leaving breathing space for my general work. By and large I like it, but there are definite issues with bulk tools and this is one of them.
For example, if you're uploading photos, an app like photoSync (http://webecoz.com) knows enough not to duplicate your photos. It will detect that it's a duplicate and use the copy that is already on Flickr.
I believe it may also recognizes duplicates when it's downloading photos.
I uploaded duplicate photos by mistake on Flickr and had to go through hundreds of photos one by one deleting them. There's no option to delete duplicates based on file name or file name/creation date etc. because Flickr has basically been dormant from a development standpoint for years.