The cars are always clean and I have never had a low fuel situation. Now, I rent cars in the Downtown Oakland area so I can't say the same for SF but thats just me. Oakland/Berkeley does have the weekend availability problem but if I know I am going somewhere on the weekend I can book as late as Friday night and still get a car I want.
The cost. I pay as low as $7 an hour for a Mazda 3, $9 an hour for an Audi A3, Mini, VW Golf. I have a small discount via FoundersCard however. Still though, those prices are pretty great to rent a car, especially since Zipcar covers gas, maintenance and insurance.
Insurance. If you do not have a waiver, you pay the first $750 of an accident, Zipcar pays the rest. If you have a waiver ($10 a month), you do not pay anything. Also, it counts as real car insurance so when you do buy a car and need auto insurance, you can say you have had continuing coverage. http://www.zipcar.com/how/faqs/what-damage-fee