He will always remain the Sheriff JW Pepper in James Bond for me! He is very much disliked by some of the franchise's fans, because he is kind of symbolic of the humor that was brought to it most notably by Roger Moore. However, a true fan knows that the silliness of the James Bond films started as early as the Sean Connery era, and that it can actually be enjoyable. I love the James Bond films for their camp just as much as for their grittiness; I'd even go as far as saying that it is the successful combination of the two that contributes to their success.
I rather liked Clifton James' portrayal of that rough, southern type, especially as a child when I discovered Live and Let Die. A caricature for sure, but a funny and rather sympathetic one. Also a great foil to Moore's aristocratic Britishness. I know he played more roles than this, but I am almost sure I never saw him anywhere else.