SPRSS
No, don’t read it SSRS (good old days :)) . It is called SPRSS and it is a fantastic , security-trimmed content Aggregator that my pal , Sahil Malik, has developed and released to the public in the codeplex. SPRSS comes in two main flavors :
1) CleanRSS.aspx: It can be replaced the ootb listfeed.aspx (http://yoursite/_layouts/listfeed.aspx) to extract much cleaner and XSLT friendly RSS feeds.
2) RSSWebPart: It can aggregate multiple RSS feeds across site collections, web apps and farms (and maybe in the future releases across our globe and milky galaxy ;)) into one security-aware bucket with the ability of applying XSLT to it.
Here are a couple of interesting usage scenarios for SPRSS.
Here is a good overview and future plans.
Here is a usage guide.
And FINALLY here is the codeplex project – http://www.codeplex.com/SPRSS