Great place just off highway 89 between Page, AZ and Kanab Utah. This is a short .9 mile or so hike from the road and not too difficult.
The very best shooting is morning, evening (golden hour) or at night. There is lots to see and it can be VERY hot so bring water in the summer. There are several trails to the various Toadstools so you can explorer several of them. Take a wide angle lens and get close...try HDR and yes take a tripod.
Only crowded in peak season (June, July, August), especially on weekends. The small parking lot can get full. Be there early in the morning if you'd like to avoid a crowded parking lot.