Among modern courses, one occurs to me at the Sewailo GC in Tucson (design by Ty Butler and Notah Begay). It's an odd course in a lot of ways but it does have a ton of half par holes, which helps. One of those is the 18th. It's 390 from the tips, where only collegiate play, but around 300 for everyone else and the direct line to the green is even a bit shorter than that. There's water right (and, yes, a waterfall). It's not a great short 4 by any means because the strategy is almost entirely about just not hitting your ball in the water, but it's certainly a unique and fun way to end a round.
I will echo the expressed sentiment here, too, that I love a birdie hole as the last at a tournament venue. Needing birdie is a whole different kind of pressure at the end of the round, never mind that it gives challengers the chance to make up ground positively at the end of the day, even before the leader might get there. But more than that it's just harder to make 3 than to make 4, even if one hole is 'easy' and the other 'tough.'