Beyond wind farms and cheese curds, these flyover states offer everything from welcoming Main Streets to rich historical landmarks