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.