Interesting. I'm based in Chicago.
That said, I literally just drove the San Fran to Tahoe drive after visiting VC firms in the bay area 2 weeks ago. We did it in a National rented vehicle (granted it was carrying 7 people..) and our gas bill was only $90. And that was in a Toyota Sequoia, so I've got to assume a compact car would be something like $40-$50 (feel free to correct me). If you rented the car for $30/day (normal rental, not a Sequoia), then it would be way cheaper.
Rental $30*4 + $40 = $160
Zipcar $75*4 = $300
I'm not trying to argue unnecessarily, I just see Zipcar as smart for trips < 2 days only. I think that's the customer they are targeting, too. Also, its great to know that as gas prices go up, Zipcar becomes a better option.