Following up on Grouped Concatenation in SQL Server and Grouped Concatenation: Ordering and Removing Duplicates, Aaron Bertrand provides four real-world examples where grouped concatenation allows you to avoid the monotony of cursors and while loops.
Aaron Bertrand uses a T-SQL Tuesday theme to demonstrate a use case for the SQL_VARIANT data type that you may not have considered: Conditional ORDER BY.