Ideally, four different directions and I'd hit four different clubs. I suppose the length doesn't necessarily dictate by itself when wind gets involved.
I lived on a course which was 190, 196, 190, and 218 and the three shorter holes all played in exactly the same direction. Wasn't terribly interesting and I sure didn't like hitting 3/4 iron. It was not uncommon for me to bogey all four of them, even in an otherwise decent round.
Hitting a wood doesn't bother me, as long as there's room. I've played some dumb muni courses with 240 yard par-3s where the green was 20 yards deep and wide, elevated three feet all around, and sloped four feet from back to front. And there were two holes like this.
Wanna make me hit driver... okay, but give me a runway.
I find 100 yarders just as thrilling. The muni that I grew up on had a 108 yarder with a big oak tree blocking the left half of the green.... if the pin was on the left third, you had to fly it over. It was fun because the tree was tall enough that the woman and junior player could go underneath it.