Air Chief Marshal RAF "Sandy" Wilson, on being knighted, was very very briefly "Sir Sandy" and I seem to remember this is what we were told [at JHQ] his wishes were.
Didn't last long however. Speak as one finds, he was a great boss for me, Sandy or Andrew. I settled for "Sir".
Very soon thereafter, a German PA announcer at a Joint thrash referred to him as "Sir Wilson". Difficult area, these honorifics .............