I might be biased but the flight paths for the final approach to land in SFO is my favorite. Often it crosses the bay, which is spanned by not one but several bridges, all visually interesting, then takes you right by the distinctive skyline of downtown San Francisco.