I have also seen courses where it seems they sacrificed too much to get that one great hole. It is a difficult balance. In fact, somewhere I wrote about it, saying it was usually a mistake to create a few bad holes to get a great one. The trend to "signature holes" in the 1980s until now might have put more pressure on architects to do just that.
I had one owner who wanted me to build a lake front par 3 desperately, but a million dollar tunnel, wetlands, and a long cart ride made it impossbile, and I didn't really think it would have been worth it anyway.