This isn't new or revolutionary by any means. I basically took a snippert i found on the drupal site and packaged it up a little and added a field so that you can set it on your content types. In my situation, unique titles only matter for a few content types (bands, venues etc...)

So here's how it works, on your content type when you are setting the fields and what not, you will see a check box that you can set in order to enforce unique titles. Check it if you want it, or uncheck it if you no longer want it. Then if someone tries to add a new instance of that type with the same title as existing content they will get an error and be instructed to correct the problem.

Pretty self explanatory.

uniquetitles.tar.gz