Houston has more homes for sale than any major U.S. city. Home buyers are gaining leverage like they haven't seen in decades, but some neighborhoods are still fiercely competitive.