Was there many years ago, but as I recall most photography required some walking on uneven ground at times. Hopefully someone with more current experience will chime in with their thoughts.
It's pretty, but not that intimate from the car. Some good overlooks but you can't really get in and among the hoodoos very well. Here's the street view from the entrance. You can 'drive' the road with keyboard and mouse controls. https://maps.app.goo.gl/XtoCWAExDL4nEWLr5
Depending on the time of year you may enjoy Catalina Highway out of Tucson, or one of the roads looping through the two Saguaro N.P. districts. The fields of cactus are quite accessible.
Perhaps the best limited-mobility option in the area is the superb Sabino Canyon tram tour.
Highways 83, 82, and 90 from Vail to Sonoita to Whetstone to Benson is a lovely drive.
The Ajo Mountain Drive loop near Organ Pipe Cactus NP is another highlight. Drive up the pretty Kitt Peak access road on the way out to the park.
I was there last year. The road has good scenery. You will be delighted with the views from the parking areas. But the real beauty is on the trails, and they are rugged. I shoot nightscapes, and do not hike on rugged at night, so went to old camp area and had fun shooting the corral, the buildings and the windmills.
