Can't help you with Cary, but a quick trip to Durham will get you to
Compare Foods which I find to be the cleanest, best stocked and nicest Hispanic grocer in the area. I didn't specifically try the chorizo (yet!), but both the pork and beef looked excellent and not as fatty as I've seen in other local Hispanic stores.