Regarding diversity of thoughts (which is to me way more important than visible diversity):
What you really mean, is that the Bay area got the "good diversity" (rich democrats), while Kansas City got the "wrong diversity" (poor white republicans).
I think those two places are similar in that regards. They are both polarized, and are both not that diverse in term of actual ideas.
Now if you want visible diversity (whatever that means), sure the bay Area got more people from a different origin but they usually all think in exactly the same way.
Source: I lived 2 years in St Louis and 4 years in the bay area.
Edit: Forgot that I would be downvoted, since it seems to be politically incorrect to say that visible diversity (what everyone is focusing on) is different than thought diversity.