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.
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.