Cary, North Carolina has emerged as America's top affordable retirement destination according to new research. The city offers year-round mild temperatures and monthly living costs under $4,000.