When done well, the super elevated tee shot produces the best combination of exhilaration and fear that can be found in the game. Exhilaration as the ball seems to soar forever in the air, and fear because the ball has such a long time to drift off line!
The best example of this that I have played is at #6 on the Desert nine of Desert Canyon Golf Resort in Orondo, Washington. The tee boxes just keep going higher and higher as you go back, and from the back tee the hole plays 659 yards. On the left is the proverbial "10000 foot crevasse at the base of this glacier", and the fairway is a small target way down below. The thrill of watching the ball soar against the backdrop of the mountains rising from the Columbia River is offset by the anxiety of seeing the ball start to drift off its target line, with a long way to go until landing.
Other super elevated tee shots are just plain fun, because the landing area in wide enough that you can just let it fly. #10 at Stone Canyon in Tucson (reachable with an iron at 622 yards!) is an example.
The oldest example (and steepest on a par 3) I've seen of the super elevated tee shot is at Gatlinburg CC in the foothills of the Tennessee Smoky Mountains. This was one of William B. Langford's (of the Langford & Moreau team) last designs and one of the few courses he designed after WW2. The 12th hole is 194 yards with at least a 150-yard drop to the green, with bunkers and a creek to the right. The 15th at ColoVista in (believe-it-or-not) Central Texas is another super elevated par 3, a 195-yarder with a 120-foot drop.
What are some other examples of the super elevated tee shot? Any really old (pre-WW2) examples out there? What is the landing area like - narrow, wide, hazards, etc.? In my view, a good super elevated tee shot is worth any hike to get up there and let it fly!