I've used it for generic audit tables, where we store something like table name, column name, old value, new value - the old/new values are sql_variant as they could be any data type.

Of course you'd never do any comparisons between different data types in these circumstances.