The name makes perfect sense once you take a look out at how the San Juan River winds its way through this area.  There are no trails, just places to camp, picnic, and stare out over the canyon.  Definitely worth a stop.