In many ways, my favourite bit of his acting was his cameo in The Time Bandits. As he broke out of Bond, there are a few films such as that, The Man Who Would Be King, and Robin and Marion where the character in some ways mirrors being the aging hero that he had become as Bond and he acts elegiacally for the times passed for the characters and himself.
Some of the reaction in Scotland, particularly by some in the public eye has been somewhat over the top hagiography. The problems presented by his comments about hitting women, and the allegations of abuse from his first wife, should be addressed rather than ignored.