I had a chance to make a quick stop out to Sugar Creek to look over the falls there.
It's located on Rt 12D between Turin and Boonville.
Google Maps: http://maps.google.com/maps?q=&num=1&t=h&vps=2&jsv=260d&sll=43.537349,-75.364645&sspn=0.009784,0.024097&gl=us&hl=en&ie=UTF8&geocode=FSdXmAId4ACC-w&split=0
It can be seen from the road, or you can drive right down in it - and I mean in it. There are a few dirt roads the lead down to the edge or right down to the water. I would advise against trying it in a car, but my jeep had no problems. The place in not posted.
From Rt 12D:
From down the road:
And a close up: