I've created several templates for my own use and find them to be great time-savers. They're good for standardized processes you run that involves multiple steps where you just change out a few parameters, but the task isn't run frequently enough to rise to the level of a stored procedure. They're another good tool to have in the toolbox.