A good and relatively recent example is the first at WeKoPa (Cholla).
The hole measures no more than 350 from the tips and the tee is elevated. It's also not nearly that long on a direct line from the tee to the green. Thus it's theoretically quite driveable. However, I doubt anyone tries much.
The hole is a sever dogleg. you play off the hill down to a fairway that sits on the other side of a large waste area. It's cape-like in that you can kind of choose to just play a little iron, or a hybrid or fairway wood, with ever increasing degrees of carry and risk, though shortening the approach.
To play directly at the green, you would actually be playing blind, to the best of my memory. At the far left side of the waste area it turns to desert and mesquite and cholla trees block the view. Nonetheless, from the tee a driver hit on a good line over those trees could reach the green or find the fairway just short of it. Missing with that shot could obviously lead to a major penalty, however.
As it is mostly played, an enjoyable little pitch and putt start. But theoretically it could really be an interesting hole.