Lake Superior is now potable again. In most parts of the coastline you can walk out about 10 feet to where the turbidity is low and just go ahead and drink the water.

The rest of the Great Lakes are unusable for many applications without processing the water first.