The most affordable place to retire in the U.S. may not have many palm trees, but boasts low housing costs and other benefits retirees may enjoy.