Mr Pittock, sorry for getting the name wrong, sometimes I just can't read very well.
Downhill or not, we saw a 667 yard hole hit in two shot with an IRON in hand.
We can use your number of 330, that's fair. Then probably 290 or thereabouts with the 3 metal second shot. So, in order for him not to be able to hit the green in two, ever, you're probably looking at 650 yards, or more, in neutral conditions. Of course then you'd have to have at least 100 yards spacing to the next tee so that the average guy can hope to play the hole and probably another 150 beyond that so that an average lady can have a decent time on the hole. And, well, that just doesn't make sense.
Now, if we're to discount the longest of players, which we most likely should, 550 or so would probably work well. Or, you could add in some type of hazard which is a difficult carry with a 3 wood, but an easy carry with a wedge for an average player and could be played around by a less than average player. The 14th at Naval Academy comes to mind quickly. Hole is around about 490 from the back markers, but it plays significantly uphill to the green (after downhill off the tee) and has a fairly deep fronting bunker, one that could be played over easily with a short club and easily around as well, but presents quite the challenge with a 3 metal or long hybrid. I've dumped shots into that front bunker more times than I can count and probably made more birdies laying up than I did going for it.