I'm a fan of Windsor Button for its selection (everything from Red Heart to oh-my-god-don't-look-at-the-price-tag silk). It's close to Park Street/Downtown Crossing. The people at Mind's Eye Yarns in Porter Square are awesome, but their selection is much smaller (though a good place to go if you're interested in spinning).