I have a cabin in Boyne City, near Charlevoix. This area is one of the prettiest, IMHO
Traverse City is beautiful too...ahhhh...And, Mackinac Island is gorgeous and unspoiled
Also, try the Thumb area for cheaper properties and rentals...Lexington on Lk. Huron a.k.a. The First Resort North (lol) is quite charming and laidback. Pt. Austin at the tip of the thumb is beautiful, esp. for camping.
"Up North" is any place north of Claire

Hee hee! I love the Upper Peninsula but it's a drive...the waterfalls up there are breath-taking...It's gorgeous and revives the soul.
But, you can go to Michigan's West coast for some pretty stuff too...Saugatauck (sorry if I spelled it right) is gorgeous. Also, Silver Lake on the west side more north is gorgeous too
Try to find someplace by the water...You'll enjoy the sunsets and sunrises

Also, you can take your family for a walk on the beach and walk to the ice cream place at night

Simple pleasures, you know?
You've got me thinking of the places I want to see and things I want to do before I move to CA
Hugz,
L