If you have the time for Grand Sable Dunes, it's pretty spectacular, but requires a day trip from Harbor Springs.
Take 123 North, get on 28 West and 77 North until you get to Grand Marais. ImageUploadedByTapatalk 21371695166.096826.jpg
Pardon the crappy iPhone snap.