Homebuyers are backing out of purchase agreements at a higher rate in certain metros and real estate agents reveal why.