In my experience RSS is at its best when dealing with infrequent publishers or niche audiences. People who don't expect to be paid for their writing because they want a wider audience, like think tanks or university departments.
That's definitely where it shines for me. I follow hundreds of infrequently-updated sites using Newsblur. It's sort of the same value proposition for me as Twitter. I'd never follow the New York Times in either place; what I want is to get beyond what's commercially viable to publish.
The nice thing about RSS is a lot of sites offer filtered feeds. I only follow a few feeds from the NYT, for instance.