Spent a few days here last Spring and loved it.  The sites were decent.  I was lucky to have one with a view but overall the site was decent.  There are quite a few campgrounds and a couple were up the mountain slightly.  Def suggest checking those campgrounds out - not much shade in those areas.  The Quail campground had ample shade.  Nearby towns - Cottonwood, Jerome - have lots of shopping, dining options.  Sedona is also not a far drive and beautiful.  Definitely recommend staying in this area if not at Dead Horse.