There are 4 different personalities that I've seen for city-states: friendly, neutral, hostile, and irrational. I have never seen any use for them, though, except that influence over hostile city-states decreases at 1.5 times the rate of the others. What do the other personalities mean?
It affects the kinds of requests the city-state makes. From the game's documentation: