As a South American and having seen European housing, the only city that has something equivalent to what's "normal" here is New York.
Not even San Francisco builds small apartments/condos. An average 2-bedroom in Europe or in Buenos Aires is 600 square foot, and that's the size of a studio apartment in the United States. I'm not saying going to extremes like Tokyo and their 300 square foot apartments (I lived in a 200 square feet studio for a couple of years, it's doable).
I did a quick search and the 1000 dollar apartments/condos for rent in New Jersey are similar in size to 1000 dollar apartments here in Montevideo... but there are no 500 dollar equivalents!
I think most people in the U.S. think they NEED that much space (even when they don't).