I think that many on this thread (including the instigator) are mistakenly equating "great" pin positions with "evil" or just difficult pin positions. Most also, seem to be focusing on what happens after you get to the green, rather than what gets you there.
To me a "great" pin position has the following characteristics:
1. It can be reached in a multitude of ways, with a multitude of clubs, from various positions in the fairways and the rough. High balls, low balls, cuts, draws, bumps and floaters can all get near the hole--IF HIT PROPERLY and with varying degrees of risk.
2. That being said, there is a "position A" in the fairway (or rough) which allows for a higher probability of getting near the pin.
3. There will ALWAYS be a way to get the ball close to the pin. Maybe it will be extremely difficult, or highly risky, but there will be a way.
4. Regardless of how poorly you execute your 2nd shot (assuming you are not OB or in H20), there will always be a reasonable chance to get bogey. If 4-putting is possible, it is not a "great" pin position--it is goofy golf.