It really is a case by case basis. If you can afford the cities, keep them. If they're holy cities, keep them. Depending on the civics you have, buildings you have, and wonders you have, new cities aren't always a drain like they look like they could be.
The only thing deserts are good...