I think zoning has a lot more deleterious effects than just creating alienating urban spaces, too. It influences everything from transportation infrastructure to energy consumption to individuals' emotional states to macroeconomic patterns. Out of all the utopian policy innovations that have backfired over the past century, zoning is probably the worst.
Houstonian here. What you say is correct --- but many, many neighborhoods in Houston have legally-enforceable deed restrictions [1]: When you buy property in those neighborhoods, you are deemed to have agreed to a (typically, very-detailed) set of restrictions about what you can or cannot do with, or on, your property. Local homeowner associations can be pretty vigilant in seeking out and going after violators.
Moreover, some neighborhoods are in fact separate, incorporated cities that do have zoning laws. (I live in one such.)
[1] http://www.houstontx.gov/planning/Neighborhood/deed_restr.ht...
What you're observing isn't the output of a free market; for that, see towns built primarily up until about the 1930s; these are traditional, walkable towns, with a coherent downtowns and organic patterns of settlement.
Since then, zoning laws and land-use planning have drastically altered the common patterns of development and led to the rise of master-planned subdivisions that are all too common today.
If not for the artificial segregation of residential and commercial uses and for equally artificial restrictions on density of development, modern suburbs would likely be smaller satellite towns, each with its own coherent walkable core, instead of megatowns with purely residential sprawl extending great distances away from the only urban core permitted to be developed.