Across the bay at KSQL I'm currently paying $6.35 for full-service 100LL (no self serve pump on the field). I'd count that in the range of "expensive, but it's the bay area so you have to pay for the line guy to live somewhere within commuting distance". We also have UL94 for $7.65, but I haven't felt like it would be worth the price difference to try it. At $6.99 I'd probably at least give G100UL a shot to see how the engine runs with it, but I'm probably not going to fly to KRHV to buy it regularly rather than paying less for LL at home. Certainly if a 100LL ban went into effect tomorrow but the other prices stayed the same, it's the option I would pick.
RHV is a good place for them to start this, though - there is a substantial push within the county government that runs the airport to get it shut down, over the usual concerns from property owners in areas that have been developed much past where they were when the airport was built. Leaded gas has come up a lot in those arguments, and so the previously mentioned $7.xx 94UL has been the *only* avgas available there for a while. G100UL coming in cheaper than 94UL and promising to be better for engines than 94UL and better for the environment than 100LL certainly seems like a win. The question, as mentioned, is whether that price is subsidized or if it can be competitive long-term.