There were two Lotus Esprits featured - both in Roger Moore films (how very 80s).

The first was featured in The Spy Who Loved Me. Possessed all of the usual Q refinements, including surface-to-air missiles and rear-firing adhesive sprayers to blind pursuers. The main feature of the car was, however, its ability to transform into a submarine (seriously, check out the video below). Once transformed, it could unleash depth charges, harpoons and a smoke screen. Though not mentioned in the final film, the car was nicknamed "Wet Nellie".

The second was featured in For Your Eyes Only, this vehicle was cosmetically similar to the S2, but mechanically different, as it exhibited no submarine capabilities (there are gadgets implied, but not seen). It was most notable for its remarkable security system, which detonated and destroyed the car when Gonzales' henchman broke the driver's window in an attempt to break in. Q Branch provided a second Turbo to Bond — in burgundy instead of white — later in the movie.

There were only 200 of these Lotus's made worldwide.