Go Waterfalling’s page on Spray Falls says that:
Spray Falls is the remotest, and perhaps the most impressive of the several waterfalls in Pictured Rocks National Lakeshore. The 70′ waterfall plunges over the cliffs at Pictured Rocks and lands directly in Lake Superior.
The falls is right on the edge of the cliffs, and the creek has not cut back into the cliffs at all, so it is impossible to view the falls from the front unless you are on the water. The cliffs are sheer for miles in both directions, so there is no way to get near the base of the falls without a watercraft. Lake Superior is too cold for swimming. :)
The Lakeshore Trail passes right over the top of the falls, and you can get right to the brink of the falls.
There’s more information on the Pictured Rocks National Lakeshore waterfalls page and I can add from personal experience that if you’re not up to the 1.5 mile hike from Chapel Beach, the Pictured Rocks Boat Tours from Munising can give you a great view as well! (one note – they can’t make it all the way there if it’s wavy though!)
More of the Pictured Rocks on Michigan in Pictures!