I use Connecting Threads thread for piecing and for quilting. I think it is a good thread to use in Stitch-in-the-ditch work where the quilting doesn't show much.
I also like to use Star thread (from Coats and Clark). Recently, I started to branch out and play with thicker threads and decorative types for quilting.