Scenario: Comment is a polymorphic model. So products, blogs, games all has_many :comments.
If I want to add a counter_cache option, I gotta add a comments_count row to each one of the different things that a comment can belong to. In my app, that's 10 or so different models.
It might be useful to store the counter_cache information in memcached.
Perhaps the syntax:
class Comment
belongs_to :comment_of, :polymorphic => true, :counter_cache => true, :storage => :memcached
# or, storage option could default to db
belongs_to :comment_of, :polymorphic => true, :counter_cache => true, :storage => :db
end