Some years ago I visited the fence at Goodyear, Tucson, Davis Monthan, Marana, Victorville, Mojave and Kingman and most of those I was visiting on business. I managed to get airside only at Mojave and Kingman!
Mojave is I think the only one that does organised tours on the ground and theres certainly no getting off the bus.
Good views can be got from the fence at all except Marana which is some distance between road and fence due to the terrain.
There used to be a good website with details of each field and guides for renting photo/spotting aircraft flight but I can't find it now! Maybe someone else knows where it is.