Definitely would be useful in some cases. But not many site's APIs have a good delegation of rights scheme, so an aggregator (which would then use your raw API credentials to all these places) would have to be a very trusted entity.

Gnip is pretty interesting...

You mean kind of like YQL? http://developer.yahoo.com/yql/console