PoorSQL is a web site where you copy the code in an input window, push a button, and get reformatted back in another window. It's basically instantaneous.
I don't know of any plug-in tool for source code control tools or SSMS that does what you're referring to there. Doesn't mean there isn't one, of course, I'm just not familiar with it.
Bottom line, any reasonable formatting is OK with me if all I'm doing is maintaining the code. For unformatted code, it's easy enough to pop it into a formatter. Personally, I think there's more productive work to do than to spend significant time trying to standardize formatting of TSQL.