I can think of a number of places where we'd do approaches in the C130 that would definately come under the heading 'interesting'! Grass strips, desert stuff, all sorts!
However, in a 747, nothing really compares to a VOR (Canarsie) approach onto 13L at JFK on a !!!!!ty night, with a late change to 13R as you start the turn. Those who've been there will understand; those who just study the chart just won't get it!