We drove 50 miles to pick up our last CSA, so I don't think that the drive is totally crazy.

That said, we are also CSA drop outs. Around here, they run about $30/week, and they are about 12 weeks long. Just as the vegetables get good (the eggplant, peppers, okra, tomatoes start coming in), the season is over. We did it 3 different years (different farms), and we never got enough of those vegetables. Honestly, though, I'm not sure that we would ever get "enough" of some of those. Last year, my dh grew something like 35 tomato plants for our family of 4 (2 are toddlers), and it was barely enough.

And, I never get enough okra or eggplant or peppers, either.
We do plan our meals completely around CSA vegetables, and I found that we often had to supplement a "4-5 person" box. That was true when it was just the 2 of us, and it was true again when it was 4 of us (1 being a very, very picky toddler, and 1 being a normal picky toddler). I'm not sure how much they expect a family to eat, but it was around 1-2 brown paper grocery bags full each week, and that just wasn't enough for us. It lasted us probably 4-5 days.
We do better taking the $30 and spending it at the farmers' market each week. If you don't get there early, you don't get the premium vegetables (that okra again and cauliflower is really finicky where I live), but we'd get there early, and we ended up with a lot more food for our $30. One of our market farmers had a CSA, and every week, I'd compare what I bought to his baskets, and I almost always came out ahead (save for maybe 1 week in summer).