No. You capitalize 'sir' when it's part of a name--Sir John--but not when it's just a respectful add-on.
Yes, miss. Yes, sir. Yes, darling. All get treated the same way.
I think BDSM goes by different etiquette, where respectful titles take on another dimension of meaning.