I think the problem most people have with gas taxes is that they are not being spent on the roads. I remember when I lived in Seattle a good portion was being spent to support metro transit.
We don’t have that problem in Indiana as there is no public transport.
As for “metro transit,” under no business model does it ever operate at a break-even level. It always requires a subsidy. Of course, once a government becomes responsible in perpetuity for whatever shortfall takes place, the incentive for efficient operation disappears. It’s an unnatural business model. So once you have it, public transport will always be a giant expenditure sump.