Tim,
I would say no, because I design most greens for either a "Sunday Pin" or "Weekend Pin" (two equally interesting or difficult pin positions) with a lot of other, easier pins. If all pins are tough, no one can step on the tee and say "Wow, tough pin today!"
I like the idea that on many, if not most, days, the green has some easier pin spots to mix and match with other holes on the course for the 6-6-6 rotation mentioned. Also, define "good" pin positions?
For tournament play once a year?
For daily play (esp. on weekends to speed things up)
For Ladies Day?
For a wet day? (upper part of green for drainage)
For a hot/dry day? (near cart path to minimize traffic on green, or in a area better for a run up shot)