where are all these Utopian “red cities” that people are apparently in favor of?

They do not and can not exist. Conservatism is an antisocial and anti-intellectual, authoritarian ideology. This pretty much rules it out of success in most conventional metrics.