Drupal modules to consider

Tell me about your acting career
rant of the day
freecycle module
timecard module
howdidido (or howdido) module tracking resolutions (weekly)
theme generator
license-plate scrabble

More to consider

List module (using node as the title, add list and be able to comment on each of the list items as needed).
What is Bella thinking?
What were "they" tinking

Survey, db creator, querybuilder

survey module

database table creator (ajax!)

querybuilder