I love the look of neatly formatted source code, but I hate writing it! For me personally, it is much easier to ready neatly aligned and properly formatted code.
There is a free tool available which will allow you to apply automatic formatting against new and existing scripts. A plugin is available for SQL Management Studio and for my favorite text editor (Notepad++). The application is called Poor Man’s T-SQL Formatter. I love the look of capitalized reserved keywords.