People who live in some of the country's most affordable states have seen their debt double over the past 10 years, a new data analysis shows.