So I take it I'll pass by the entrance to Sitting Bull Falls while on NM 137 headed to Dog Canyon from Carlsbad?
Yes. It is well signed. Turn off is 2.7 mi south of the Dark Canyon intersection with 137, and 7.8 miles from 137 on a dead end road.
It's a nice introduction to the abrupt transition of the Guads from plains to canyon.