It really depends on the wind direction. Generally, the flight path (pre-9/11) was right above Manhattan, sometimes along Broadway and a sharp turn to the right over Harlem, over Co-Op City, and into LGA. Now, I am noticing more planes flying over the Hudson River, as opposed to directly over the City. The other approach I am familiar with takes you over Brooklyn and along the East River, which is another great view of the skyline if you're on the left side of the plane. I flew to Richmond in January from LGA and we flew along the Hudson right over Ground Zero which was really wierd and disturbing.
The third flight path takes you over Queens and out over Long Island Sound and a turn back to LGA over Co-Op City.
If it's any consolation, KLM flies into Newark with a 767-300 as well.