Home prices are dropping in U.S. metros where for-sale inventory now far outpaces demand, including many Florida and Texas cities.