The question was whether there is any length that cannot be a great hole. My answer was that I cannot see a 350 yd hole being a great par 5.
Isn't par just a way of keeping score? You could impose a "par" on bowling or any individual game or sport where a player accrues points. The point of the game is to hit the ball fewer times over 18 holes than your opponent(s).
Are there a lot of 350-yard holes out there that have been designed to be played in three shots, or 150-yard holes designed to be played in two? I'm not sure an architect would get a lot of repeat business by building such holes.
I'm sympathetic to the view that great 550-yard+ holes are rare because for all the intrigue that the "body" of a golf hole can bring, the last 50 yards and the green are most important. Rye, at 6,300 yards, par 68, gives competitive players all they can handle when it hosts tournaments. While I have all the confidence in the world that great courses can be built with one or zero 500+ yard holes, I wouldn't outlaw them, because holes like the fifth at the Cascades and the 18th at Yale are among my favorites anywhere, of any length. If they're rule-proving exceptions, though, so be it.