We went on the Journey Behind the Falls tour today. It consisted of a platform near the bottom of the Canadian falls, and a tunnel that goes behind the falls themselves and includes a couple of places where you can walk up right near the water. Not too near though.
Here are a couple of short videos.
Inside the Red Head's Head 