In November 2007, Golf.com published this list of its favorite holes in Arizona. While the list is a bit dated, these are still very solid picks among the best courses in Arizona, all of which are accessible to the public. Below are the holes specifically on courses around Phoenix.
The full list can be accessed here: 10 Most Dramatic Holes in Arizona
6th Hole, 355 yd par 4 - Boulders Resort - South Course, Carefree
4th Hole, 467 yd par 4 - Gold Canyon GC - Dinosaur Mountain Course
11th Hole, 175 yd par 3 - Grayhawk GC - Talon Course, Scottsdale
6th Hole, 180 yd par 3 - The Phoenician GC, Scottsdale
17th Hole, 209 yd par 3 - Sunridge Canyon GC, Fountain Hills
17th Hole, 332 yd par 4 - TPC Scottsdale - Stadium Course
3rd Hole, 564 yd par 5 - Troon North - Monument Course, Scottsdale
8th Hole, 605 yd par 5 - We-Ko-Pa GC - Cholla Course, Fort McDowell
Golf.com - The 10 Most Dramatic Holes in Arizona