There are a lot waterfalls near Marquette, Michigan (where I stayed when I was in the U.P.). Most are kind of off the beaten path, and require a bit of effort to find.

The structure in the photo above is an aqueduct that leads from the Forestville Dam, a short ways up the Dead River.