For the specific question of drifting on the Great Lakes, doing so is effectively suicide.
First, there's the matter of traffic. The Great Lakes are a major shipping lane, with upwards of a hundred lake freighters, numerous ocean-going freighters, barge traffic, and other ships traveling at all times -- not counting small private vessels. There's a very real risk that your canoe will drift into a shipping lane and be run down, without the other vessel ever being aware of your existence.
Second, there's the weather. The Great Lakes are not known for their calm temperament -- every year, boaters drown when storms abruptly form or blow in. If you're asleep, you're not keeping a weather watch.
Third, there's the surface condition. The Great Lakes are large enough to get ocean-like waves: even if the weather is calm where you are, it's quite possible for high waves to roll in from some other part of the lake. A drifting canoe is almost certain to turn broadside to these waves and capsize.
Fourth, there's the size. Lake Ontario has places where you can wake up to find yourself 25 miles from shore; the other lakes are even bigger. Can you picture yourself paddling that far, possibly facing adverse winds, rough seas, and ships so big they can't even see you?
If you really want to sleep in a drifting canoe, do it in a pond where you're not facing these hazards.