I've still never made the trip there. Can anyone say what's a realistic drive time from the Detroit area?
My focus for big trips that involve long drives is generally east, not north. I can get to Whiteface, NY, in 10.5 hours. 12.5 hours gets me to Sugarbush, VT. (Heck, 6.5 hours to Bristol, NY.) Sooner or later I want to go to Bohemia, just to try it, but not this year in low-snow conditions.
You can get to Houghton in under 10 hours in normal driving conditions. Bohemia is 60 miles north of there but as far as I can tell your best bet for lodging and some modicum of nightlife is in Houghton or Copper Harbor. Stay there, drive to/from Bohemia each day.
Also around the 10hr mark from Detroit, as long as there are no issues at the border, is Mont Tremblant, QC. There are some other mountains in the Laurentian range near Montreal, too.