I've used the sql_variant type once, in a TMR database used to evaluate data in other databases. I needed to be able to store data from other databases without knowing up front what datatypes would be used to evaluate data frequency, min/max values, etc.

Doesn't work for blob fields, but for what we were using it for, it worked fine.