Even though I generally agree, for the sake of keeping it interesting, let me push back a bit.
I think that 480 yard holes can be good, but usually aren't.
Even in this thread we're talking about distance, and not talking about strategy. If the 480 yard hole is a penal runway (they usually are), then I typically can't stand them because they are boring, and just reward power for the sake of power.
If the 480 yard hole is a strategic marvel, then I typically love it, but it's usually an obvious par 5, which sort of defeats the purpose of the discussion.
I think most holes that are a drive, fairway wood, and a chip, when they are very strategic, appear to be long par 4s, and not short par5s, but play as 4.5s.