Check out this book by Rich Karlgaard, Editor of Forbes: “Life 2.0”
He has stories of business people (mostly small) who have left the big city behind to improve their life. Discusses the pros/cons and gives great insight into various types of towns: College Towns, up and comers, bohemian towns, middle of no where, etc.