Apart from the other examples, I've also seen them be used for internationalization. http://i18n-tag.kolmer.net/
var query = sql`select * from user where id=${id}`
Similar for html, preventing injection. You just need to implement the corresponding functions.
For example https://github.com/felixfbecker/node-sql-template-strings
var query = sql(`select * from user where id=${id}`);
const NameTag = styled.div` font-size: 12pt; margin: 3px; `;
Apart from the other examples, I've also seen them be used for internationalization. http://i18n-tag.kolmer.net/