All the cities you mention are tier one Potemkin cities.

Try go to the country side to see the real China.

For the racism part, I wouldn't say that signs with "no foreigners" in shops are common, but I have seen them a couple of times during my 5 year stay in China.