I remember the old HK runs into Kai Tak. There was the final approach turn and run between the condominiulms where you could see those people hang up their washing on the balconies !
I've had a few scary runs in the past and am not a great fan of flying. The one that immediately comes to mind is a short haul flight with Lufthansa between Franfurt and London. It took 2 hours delay to get airborne because of storms over the UK. On approach at Heathrow I was looking out of the window seat with the plane about 1000 feet before touch down and the wings all over the place. I remember thinking 'no way is this one going to land here'. Within seconds the pilot had nosed up and cranked the engines on to full for a 'go around'. Very calm announcement stating that we would probably try another airport (German pilots are just GREAT at times like this). In the event we landed with no hitch at the second attempt. Sometimes you are very glad when you fly Lufthansa.
Bumpiest flight was probably Minneapolis to Cedar Rapids Iowa in a blizzard, in a twin-prop. Another delayed take off and the aircraft was 'cold' when we hopped on board. There were quite a few Rockwell Collins avionics engineers on board that night and most of them looked a bit on the nervy side.