For "traditional" golf in the Arizona here's a sample. Keep in mind that great in AZ is good in Mass, Jersey, MN, etc.
Phoenix CC (private)
Paradise Valley (private, fun greens, deep bunkering, interesting routing, BEAUTIFUL clubhouse)
Papago (public, great skins game on Monday, if they could get the greens to a 10.5 it would be make it that much better)
Encato Park (public, see Forrests comments, played there twice and both times the greens were running fast and true which was kind of surprising, great for the ego
)
Moon Valley CC (private, after mAnnika shot a 59 they made the greens CRAZY, especially 17 and 18)
Pinnacle Peak CC (it's OK)
Desert courses worth a look:
Legend Trail (public, fun routing, favorite Reese course to date)
TPC Desert (public, cheap, walkable)
Desert Mountain (private... As far as I'm concerned, Desert/target golf doesn't get any better than Chiricahua and Geronimo. Outlaw is a shot-makers course, especially with the shaved dormant around the greens. played yesterday. Bring your A game
)
Two clubs have really impressed me as of late:
Silverleaf and Golf Club at Scottsdale (if you can play both or either, do it. For the desert, they are solid)