I've flown to airports all across the nation, and in my personal opinion not one holds a candle to my current hometown of San Diego. To the best of my knowledge there is a single approach in the world that gets closer to the downtown city center, and underneath the ground slopes upward until the tops of buildings feel like they'll nearly skim the landing gear (in fact a parking garage once had to have a portion of its roof removed as a hazard)
Skip to 7:45 or so for the good part
• Video Link
In certain parts of downtown you actually look
down at the aircraft as they land
• Video Link