This time last year I wrote about how to share templates within a team of DBAs http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/62933/
I use templates in conjuncton with the SQL Prompt and the combination of the two is greater than the sum of the parts.
What SSMS needs is a simple macro language. Something a bit more than SQLCMD mode but not as heavy weight as powershell.
What SQLPrompt needs is a few more constructs like their $CURSOR$ place marker.
$DATE.YMD$ would be useful as would $USER$, particularly as my company shares the SQL Prompt 3 Snippets.XML file between DBAs.