Love the smug look Bond gives the other agent in that clip.
Another similar fictional use of a VTOL aircraft, though using the two seat Yak-38 Forger-B, was in a Quatermass novel, in which one brought a Soviet scientist to London, landing in Hyde Park and using special pods to collect samples of material floating in the air on the way. The Forger was destroyed when a drunk mercenary managed to press the self destruct button while playing about in the cockpit. Oops.
I always thought that the pod idea is a great one but what circumstances could it be used where either insertion by submarine or helicopter or a HALO jump would not be available.
But the use of a two-seater for SOE-style insertions and extractions -despite the noise- could have been used under the right conditions.