I am planning on writing and contributing my first Drupal module in short order. Since I am going to make it for Skejo.com anyway, I might as well offer it to the community. It will be a module that will automatically mass delete old revisions of nodes to avoid database clutter. It would takes 3 to 5 clicks a revision to delete old stuff using the hooks that are in place now, but with what I have outlined, you can set this module to delete node revisions that are older that 'x' weeks or months (of course never deleting the current node revision).
This may be handy for community 'wiki' type sites that may go through many revisions while getting the document right, but then it will stable out and be static for the months/years afterward. Keeping all those old revisions after the fact is not really needed and just clogs up the database. Lots of small scale websites might have as little as 10megabytes of database storage available, so every byte counts.