Based on a question in the forums, I went looking for a module to handle content spotlighting, selecting a single item (specifically a user) to be displayed separately in a Featured Content block and rotating the selected item on a cron basis (e.g., weekly). To my surprise, there doesn't seem to be one.
I'm hoping one of the Drupal ninjas will post with a solution, but if not I may try my hand at writing it myself. The module would need to:
Ideally this same module should be applicable to any content to allow it to feature users or stories or custom content types, though I think I'd focus on users specifically first in order to keep things simple.