Thinking (very little) about this, I can’t think of a reason why such a hole would be automatically bad. However, I can only remember playing a couple of holes like this and I thought both were terrible.
Example one: Badlands, Las Vegas, Desperado nine, I think. A whole bunch of rather odd holes playing up and down a dry arroyo. Desert target golf on steroids. I remember one hole that required a 160 yard tee shot, followed by a 200+ yard approach. No ponds here, just desert, rock, and brush. I wondered how a high capper could play it, then wondered how the course made any money. Another image came to mind as well: green complex mounding that would give guys on this site nightmares.
Example two: Falcon Crest, Kuna, Idaho (near Boise), 18th hole, I think. The tee shot played out to a fairway with a lake along the left side. No matter what club is used off the tee, from a short iron to a driver, the second shot required a 200+ yard, forced carry, approach over water. The way around the lake to the left of the pond was totally native. Perhaps the dumbest hole I’ve ever seen. I played the course right after it opened and it was still basking in all of the glory of its creation and creator, a landscape contractor owner’s first effort. No doubt the hole has been modified since by giving us geezers a way around the lake to the left (after a quite few Tin Cup rounds). I don’t remember where the forward tees were.