Dave Mattingly goes spatial on Cleveland:
From here, we can:
zoom in for more detail
hover over a building, road, or other feature to see its name or other column
display a label on the results
apply filters to only show parts of the data
change the widths of the features by changing the STBuffer
do lots of other cool stuff
Spatial types and display in SQL Server has always been a weak point for me, so I enjoy seeing the fruits of somebody who is very good at it.