I made a set of dish cloths for my mom, some using Cotton Tots, some using Cotton Ease, and I made a set for my grandma using Sugar N Cream (because I liked those colors, not because I was skimping on granny!)
I would say that the result of the Cotton Tots is softer than the SNC, though I am not sure how they "age", that is if the SNC becomes softer over time or if the Cotton Tots/Cotton Ease hold up as well as the SNC.
I liked working with the Cotton Ease the most, but I liked the Cotton Tots too, and will use it again...I really don't care for the SNC. I don't like yarn that "fights" me, and I felt that it put up a little bit of a fight. It kind of reminded me of rope.
The nicest cottons I have worked with that were soft and suitable for apparel were Online Linie and Berroco Touche. The former is pretty pricey and I would say not a good value (it is nice, but doesn't "earn its keep", IMHO). Now that I look up the Touche, I find that it is only 50% cotton after all! It was a little expensive, but I thought very worth the price.