Is there a modules "wish list" anywhere?
Check out the Contributed Module Ideas group on groups.drupal.org.

The Google Summer of Code group can also be a good source of inspiration. Some of the ideas may not be big enough to sustain a student for the entire summer, so they don't get picked up otherwise.