The Clown Prince of Crime
Super Freak
The Craig Bonds really missed on the gadgets. I guess it is too cheesy to have them nowadays. The MCU has cheesy humor and makes hundreds of millions.
Q didn't show up untill Skyfall, and we he did, all he gave Bond was a gun and a radio. Having said that, it made sense and that whole scene was probably the most interesting and meaningful interaction between Bond and Q in any of the Bond films.
As for the gadgets being too cheesy, it depends on the gadget. Some gadgets are too good it makes you wonder why Bond doesn't use them in other films, like Brosnan's X Ray sunglasses. He literally had X-ray vision in one scene and never used the glasses again. A bulletproof suit like John Wick's was such an obvious thing for Q to give Bond and no one ever thought of it.
Anyway, Q and Bond using gadgets are essential parts of the 007 brand, so much in fact that other films copied the concept of the "gadget" maker to help the hero, so I hope they go back to that in the reboot. I don't want Q to just be a computer guy that helps Bond like Oracle helps Batman.