I should have clarified, I have used Google, Bing (sometimes better) and the generics and played With EarthExplorer but I was under the impression there are new daily views of some locations
If you are talking about the episode from this season on Lake Erie, Realtree has the right link. Modis imagery is what they use for great lakes daily satellite imagrey.