I have been using Aurifil 50 weight for piecing and really like how flat it makes my seams. Not all 50 weight is that fine. I also use it to quilt sometimes when i want the stitching to be fairly fine.
I also like superior threads for quilting and have tried both their cotton threads and polyester in different weights depending on the look that I want.