In answer to Charles request to see a script that puts all this info into use with a script that runs on a timed basis that creates a list of index recommendations to create and drop.

http://blogs.msdn.com/queryoptteam/archive/2006/06/01/613516.aspx

I use it on my system and its a good tool for advice but as Gila said you will often find that you get

very similar recommendations from it.