Based on a purely economic stance, if the drilling can be done without screwing the area up, I'm for it. If it kills the fishing and tourism due to the fishing, than I'm against it. Now about 20 miles north of there is one of my hunting areas. There's lots of gas wells there. It doesn't screw up the hunting. The difference is that it's not over the Au Sable River. My concern is strictly with the river, its character, and the trout fishing that goes with the river, which needs to stay around 60 degrees.
The current price of gas is quite effectively killing tourism in Michigan. Northern lower and UP are going to be particularly hard hit. Us "downstaters" (as my Traverse City-based sister et al sneeringly refer to anyone living south of the 45th Parallel) are skipping our usual summer sojourns northward because of gas. We're finding fun in our own backyards, in our own or neighboring counties. We're keeping our tourist dollars local. That accounts for a great big chunk of "upstate" tourist dollars.
Damned if you do, damned if you don't.