I'm a Costco booster, and I have storage space. One of the greatest feelings for me is returning from a Costco and knowing I have enough in the house to last a month for a family of four.
But your second point is spot-on: this strategy has to be augmented by weekly (or more) runs to get fresh food. I like to make fried rice with vegetables, so having a local market is essential.