I guess it depends on what your opinion of "good" is. If you are looking for a course to replicate what "good" courses are like around the major metropolitan areas of the Midwest, leave the clubs at home. If you don't mind some courses that can be a little rough around the edges, then you have several choices.
The best in the Keweenaw is Portage Golf Course in Houghton. It is owned by MI Tech and is run very professionally and quite frankly probably would be fairly similar to an average to above average course around the big cities. It is located on Hwy 41 just outside of Houghton on the way to Chassell.
Next would probably be Calumet Golf Course, which is just SW of town on the way back down to Hancock. There is a sign at the highway directing you where to turn.
The next two are very close behind Calumet's conditions and are probably tied for their shape. They are the Keweenaw Mountain Lodge just south of Copper Harbor and Wyandotte down by Twin Lakes. I think the edge in attraction would go to the Mountain Lodge on these two, not because of conditions, but because the views from many of the holes at the mountain lodge are second to none and the food at the lodge is also excellent. The manager there know's his stuff and has a very well trained staff, so great place to have dinner after your round.
If you want a REALLY unique course, then Sandy Pebbles is your ticket. It is on 5 Mile Point Road not far from Ahmeek. The course was designed by a man who lost his sight in the Vietnam war and includes some very interesting holes, like #2 with a 90 degree dogleg right! The same guy owns the course and has a grounds keeper to keep things up. With a more limited budget, it is usually in the roughest shape. However, the greens and most tee boxes are watered, so at least those are green!
Portage is the only 18 hole course in the Keweenaw. All others, you just tee off from different boxes to play the "back" nine.
-John