The number of cities you will create (or keep) during a game, varies greatly on several factors:
Do you NEED a city there to block an enemy access & grab some important resources? (may imply you are willing to settle even on bad spots with no essence or low food / production)
Do you have a good spot for each type of city you need? (a high production city - fortress - near a forest and with some clay, preferable with at least 2 essences, a town with loads of food anything with 1 essence or more is good preferably near river / sea, and a 2-3 essence with decent production and food for conclave).
Can you safely expand (no big bad Joe monsters roaming to waste all your effort, no warring neighbors nearby, it has a decent / good / perfect settling spot & resources) - your Unrest penalty won't kill you if you drop 1 more city.
Should you keep enemy captured cities? Do you have spells & mana to lower unrest to a decent level? Do you have the necessary money to rush unrest reducing buildings to turn it into a productive city and not cripple your Kingdom / Empire?
Usually Empires have an easier time managing more cities, while Kingdoms should stay smaller but more specialized.