When to go
October is generally the best time to capture the varying fall color and misty conditions. The peak colors at this location will vary from year to year, but since you're close to Lake Superior, the colors tend to turn a little later than in the surrounding areas. The colors could peak on October 1st or they may not peak until October 8th or 9th.
Visit this place during sunrise since you're facing east at the overlook.
Field tips
Try to bring more than one lens! If you have two lenses, you can have a wide-angle and capture the entire scene or zoom in on the bluffs and have a more compressed image. It's also nice to bring panoramic gear for another perspective.
Try to balance your foreground, the lake, and sky in your composition.
It's good to try some bracketing or use a neutral density filter to balance out the dynamic range.
It is possible to work the scene by moving around, but it does tend to be crowded so I think it’s a good idea to scout out your location in advance. I usually scout it out the night before just because it is going to be dark when I get there and will be crowded.
Current weather
Buckshot Landing, Michigan
Clear
Blue Hour
11:04
39o
Partially cloudy
Sunrise
11:35
39o
Partially cloudy
Sunset
24:31
39o
Partially cloudy
Do nearby
The area has a lot of recreational opportunities since it's the largest wilderness forest in the state of Michigan. It's also right next to the escarpment trail that runs a couple of miles along the edge of the cliff, so you can go either east or west on the trail to shoot some great shots of the river valley and mountains.
Porcupine Mountain Wilderness State Park has a tremendous amount of hiking and waterfalls very close by — make sure to head there as well!