While the $65 annual fee for a basic Costco membership can deter some shoppers, fans of the members-only warehouse club argue that stocking up on staples can quickly offset the cost.