The longer homeowners own, the more likely they are to be grateful that they no longer have to rent, a new survey shows.