The Thames boat chase in TWINE... (the chase in LALD is ok except it's dragged out far too long by so many scenes of J.W. Pepper and his bumpkin Police unit.. )
The bigger What-was-the-damn-point moment in a Bond film... Elvis' toupee in Quantum of Solace OR Promising us that the BMW in Goldeneye had stinger missiles but then we never, ever get to see them used?