Adding a mode where the tabs would toggle from one to the next in a slideshow mode.
Features would include:
> Start/Pause buttons
> Default on - Default Paused admin options
> Transition effects (perhaps)

I am currently working on version 06.00.00 which will have some new skins that do a slideshow.

Aggregator 6 released today has a new template named Featured Content Slider that makes it easy for you to show a nice content rotation module. You can find the demo here, http://www.dnnstuff.com/Modules/AggregatorTabbedModules/AggregatorDemos/jQueryFeaturedContentSlider/tabid/391/language/en-US/Default.aspx.

You can also hide tabs on any of the jQuery tab templates and check the rotation option if you don't want to use the featured content slider.