Pretty much everything north of ~Flint is good if you just want a house by a lake, The UP especially so. Wisconsin and Minnesota have fewer lakes, but they are also good, and have better roads. If you want to go out on the Great Lakes, skiing/snowboarding (on dunes?), hiking, kayaking, hunting, or fishing, narrow down your choices accordingly and take a visit to check it out.