He was a badass in The Spy Who Loved Me, though. At his best, Moore was awesome.
More dropped a guy off a roof, shot a guy in the balls, ski'd off a mountain with a Union Jack Parachute, kicked a guy out of a moving train, and drove a car into the ocean. Oh, and he led a naval assault on the villain's lair.
Not to mention his line he said to Anya when he admitted he killed her boyfriend (including the look in his eyes when he says it):
When someone is on ski's at 40 miles an hour trying to put a bullet in your back, you don't always have time to remember a face. In this business Anya, People get killed. We both know that. So did he. It was either him or me. The answer to the question is yes. I did kill him.