JJSE,
The first tee on the Upper at Baltusrol is right beneath the dinning room windows, but, by far, the most intimidating tee shot has to be the first tee at Merion, hard by the patio.
As you prepare to hit away, the chatter, and sounds of those serving and eating fade to a dead silence, and suddenly, you realize that you are the sole focus of everyone's attention.
This awareness can be frightening.
But, after you've hit away, and are walking down the fairway,
you gain an additional perspective with regard to those who were watching you, one of courtesy and manners as exhibited by the dinners who were kind enough to pause, so as not to distract or disrupt the golfer teeing off.
I think the first tee at Merion is one of the most unique spots in all of golf.