Some examples...
Use colored tights to do some winter color-blocking. (Cobalt blue tights $5.99 from TJ Maxx)
Create interest to an all black dress (that is also super-short) with colored tights and fun shoes.
Bring leather shorts into cool weather with black tights (black tights from Target)
Don't be afraid to wear your tights with open toes shoes. Just make sure the shoe is substantial enought to handle it.
Unlike this one... too summery and strappy for opaque tights...