I think the location of the first tee, more than the actual tee shot to be played, is what makes it memorable. For me, first tees that will likely be watched by a gallery are memorable.
Examples:
Merion (East)
St. Andrew's (Old)
Lahinch
Oakland Hills (South)
Ballyneal
Atlantic City CC
Kingsley Club
Opening Tee Shots with great vistas can be memorable as well...
Crystal Downs
Pasatiempo
Muskoka Bay Club
Sanctuary (Colorado)
Shinnecock Hills