Since Digg has millions of stories on our site, we always run into the "Uniques Exceeded" issue for story-level reports (Diggs by stories, shares by stories, etc.). after the first few days of the month. I'd then have to go into Data Warehouse or Discover if I want a particular query such as, Most Shared Stories this month, or all stories with the keyword "cat," for example.
Ideally we wouldn't have the 500,000 unique records limitation in SiteCatalyst, but i can imagine the performance issues associated with that. As an alternative, I'd like to see a the 500,000 records with the MOST, say, pageviews or instances, or whatever the default metrics is for that particular report.