A mayor's power is often seen, even when compared to a governor's or prime minister's/president's power, as having the highest potential of actually being appreciated, as the latter positions come with having a bunch of invisible pieces and filters to tend to, even supposing you decided to be dictatorial about things. Despite this, or maybe in spite of this, whenever I see very loved and communal individuals, they see it as above their area of motivation to run for local office. There isn't a single city, town, or village I've been to where the mayor's level of connection to the people around them isn't overshadowed by that of at least some of the citizens, in fact I see the mayor, district attorney, sheriff, town judge, etc. in my own area as being visibly condescending blowhards who are bedfellows with the local activists who are known to have no issue ruining childrens' lives the Ally Bank way. Even to you I'd recommend running for some form of town office, though with you too, I doubt the challenge would be stepped up to. You could make a difference in your own little fragment of the world.
So considering most people I talk to wouldn't take up the suggestion to run for something like mayor, district attorney, sheriff, town judge, etc. what is your local government scene like? And are you different from those who won't step up to the challenge?
Our mayor has been a mixed bag. He has been fairly progressive in terms of improving public infrastructure, but has had a poor track record on social issues.
Currently, he is courting a scandal involving a violent altercation at a safe injection site where someone got bludgeoned to death. His response was a rather draconian closing of the facility (he claims it's only temporary) and essentially telling the homeless in the area to get lost. As you might imagine, this is not going well.
I have no interest in running for any political office, though if I did, the city council would likely be highest on my list. I actually enjoy watching them in session from time to time on the local cable channel, as there is less partisan bickering at the municipal level and, as you say, the decisions they make are more likely to affect your day-to-day life.
I am sort of half-heartedly angling to get on a committee involving the city's cycling infrastructure, but that's about the extent of any political ambitions.