If you are hitting a shot you know you probably should not attempt, but you are doing so because you want to anyway, you are probably playing a great hole - or a really bad one.
For most of us, the best tee shot on 16 at Cypress Point is probably a layup, but none of would probably choose that option.
If you have 210 yards into the green at 13 at Augusta National from a sidehill lie, you are probably going to try and hit the green, even though laying up probably would yield a better score on average.
On the other extreme, I recall hitting a tee ball over a house on a hole that doglegged right. There was no real advantage to doing so but it was a fun thing to try. That is a bad hole and hopefully a house that never sold.