Years ago we were flying from PIT to TPA and the pilot came on and announced that we would be able to see the eye of a hurricane in the distance. He had received permission to circle so both sides of the plane could see it... To this day, that is one of my favorites...
A couple of weeks ago, we took a different approach into SFO and circled around the bay... The FA walked through first and announced that we would be doing this approach and pointed out most of the sites. We were low enough to get some great shots