Juneau, or PAJN, has an incredible approach from both runways. From 26, you fly over the small capital city, over several glaciers and mountains, and over water as well, and you make a turn on short final. Runway 8 is also breathtaking, you fly over glaciers as well, and then over water before making your landing. Overall, PAJN is an amazing airport for approaches and landings.
I also like Innsbruck (LOWI) and Paro (VQPR). They both have scenic and hard approach and landing sequences as well.