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.
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.