Heavy competition in today's pricey housing market has sidelined some first-time buyers, especially in major metropolitan markets. These markets may be best for home shopping.