Red Gate has a pretty interesting tool called SQL Refactor:

http://www.red-gate.com/products/sql_refactor/index.htm

The “Layout Code” feature looks awesome.  It basically takes a terrible looking select statement and turns it into a nicely formatted block.

Here is a code project article that shows some of these features:

http://www.codeproject.com/showcase/SQLRefactor.asp