Does Franz Sanchez have the most vicious main Bond villain death?
The only ones that I can immediately think of that might come close are Karl Stromberg in The Spy Who Loved Me (he quite literally gets shot in the nutshack), Alec Trevelyan in GoldenEye, and Elliot Carver in Tomorrow Never Dies. But what happens to Sanchez just seems to be the most sadistic and graphic.
http://villains.wikia.com/wiki/Main_Page