It varies by city. In some cities, mayor is barely more than a figurehead.
But regardless of power, what the NYC mayor does is widely reported and it's often a political stepping stone (if not always successful) to something greater.
Mamdani in particular is a celebrity right now, and with the reputation of the Democratic party in shambles, many eyes are on him.