I'm a fan of the 18 at Pebble, like Ran mention in his course review, it's a hole that has become better with technology, although technology getting better may render it useless. I do debate the merits of the left green side bunker though as it pushes the golfer away from flirting with the cliff.
I like most of the ones mentioned (Oakmont, Pine Valley, Stonewall Old, Dismal Red, Lawsonia, Ballyneal, etc.)
For starters, 18 at Winged Foot East, which, if I remember correctly, has an incredible green.
There's also 18 at Kiawah and 18 at Old Macdonald
But for fun I'll add two at lesser known courses, one which probably most will applaud here and another which may raise a few more eyebrows.
For starters, I'm a big fan of Claremont's 18th. The way that green is benched into the hillside next to the clubhouse and the slope of the fairway makes it one of the better finishing holes I've seen, but I'd be surprised if anyone mentioned it here. A few of the members play it back from the 17th tee, which makes it a brute of a hole.
The other is Bayonet. I like the way the hole descends and then ascends to the green and that it faces a demanding tee shot but then opens up, inviting you to go for it but making the task no easier by dotting the right side of the fairway and green with bunkers.
I'm not sure why, but I've always enjoyed playing Bayonet.