Jason, I like the look of both those holes. They are uphill, but not overly intimidating to look at.
Sean, painswick 5 is about the height of Montecito CC 8, can I ask what the length of the hole is?
Anders, yeah that Lundin hole looks pretty extreme! The crail hole looks good too.
John, For the example I was thinking of the shorter tee would be about 120 yards with no forced carry. Yeah, I think 175 yd steep uphill over a hazard is a bit too much, if only because many players couldn't get the ball high enough with a long iron or wood. 18 @ pasatiempo is good as you pointed out because it has variety in the tees and plays somewhat downhill to augment the forced carry.
Joe, 8 @ deerfield looks similar to 3 @ pasa - about the same length and rise. I agree that any steeper than that could become a problem.
Sometimes I wonder if the sharply downhill holes play more difficult than the uphills at times because of problems judging spin & distance. The 11th at Sandpiper is a local hole with a severe dropoff to the green. It seems to be tougher than any uphill hole I can think of from the back tee.