My local Costco carries the fair trade artisanal coffee brand that is roasted in my city, just in a 3 pound bag of beans instead of a 1 pound bag of beans like at the bougie grocery store. I can understand not wanting the Kirkland brand coffee, but that is far from the only coffee brand for sale at Costco. I am a coffee snob of the highest order and I buy my beans at Costco.
They've got decent beans, but you can't get anything with more exotic processing techniques, e.g. lactic or carbonic maceration.
I get my beans for my summer cold brew at Costco, but my typical pour over beans elsewhere.
That's true, but mostly due to simple logistical constraints, more exoticly prepared beans generally don't keep as well on the shelf and need to be used shortly after roasting. I do a pour over in a Chemex every morning and use the beans I buy at Costco which are a locally medium-roasted, but not specially prepared. For more exotic stuff I get them directly from a local roaster in smaller quantities to be used within a week.