The Expressway visual into LGA is a landing in itself. A lot of times, the controller will ask planes to "hurry it up" from what I've heard, and those planes will make the turn a little closer to the airport (instead of loooing over Main Street in Flushing).
Even standing on Main Street, and seeing the planes turn onto the visual is great. They are so low, I cannot remember any time I've been on that approach. I'm always on RWY22.
Speaking of LGA, I think the approach to any rwy is interesting. You have RWY4 where you fly "along" the city, over pretty populated neighborhoods, and right over the Grand Central. RWY13, you come up the Hudson river, fly right over Harlem, and if you're on the right side of the a/c have a perfect view down all the avenues in Manhattan. RWY22 from the south, you come up the hudson, then make a 180 turn over the Bronx/Westchester. then it feels like you're gonna end up in the water when the little "dock" runway comes out under you.
Canarsie VOR is really cool, not because of the proximity to the groud really, but you fly just left of JFK, so you get an overview of the airport before landing. You can also see the planes landing ahead of you, which is rare at a lot of airports. I flew into JFK this summer onto the Canarsie approach in a t'storm (touched down just as the heavy rain started to come down, and lighting started hitting close). It was really something. I think we might have been one of the last a/c to land at JFK on the approach, as I only saw another 767 landing after us.
BTW - This was on DL, and they were using 13R for departures, but we still used 13L, I must say, the taxi is a long one. We taxied down RWY 22R I think (I guess it was closed) for a long time.