Any great courses, should also be great from the forward tees. Name one that isn't?
Since I'm not a fan of too many vista tees, especially the ones you need to back track up hill to reach, many modern courses that have the forward tees at grade, have better looking holes that interfaces better with the architecture. And in most cases the big bunker complex guarding the inside leg of a turn, looms much larger from the forward tees, and is therefore, more impressive and intimidating.
Many of the prairie links courses I frequent, when played forward are just a blast. Tempting the golfer to go for it, while exacting a huge price for failure. But still allowing for heroic recoveries. Who could ask for more than that?