I've looked at a number of SQL Intellisense programs and chose "SQL Assist" based on two features - templates and sql formatting. Their Templates are extremely powerful and configurable. SQL formatting is very good and is useful when I post some long query that I get from Profiler.
Down side: It runs only on Visual Studio for the moment.
P Barbin