See https://www.aircela.com/ and many other e-fuel startups, that one makes a very pretty image of a "personal fuel synthesizer" which makes about a gallon of gas a day which is about what my wife and I use.
Cool! They have the numbers, too. Their system needs electricity for electrolysis, 75kWh per gallon of fuel. Compare to 0.24-0.87 kWh/mi for electric cars.
For a car that gets 30mpg that is 2.5 kWh/mi which is 3x worse than the the least efficient electric car, 10x worse than the best.
Still people will want to keep classic cars running in the future and there will be some market, enthusiasts will be willing to pay upwards of $8/gallon. Methanol-to-gasoline fuel is very high octane, around 96, which should keep old engines happy.
The most significant market, I think, for e-fuels are large vehicles such as construction trucks and farm tractors. California has absolutely terrible air quality not just in cities but in ag areas and it would be ideal to synthesize