You have one of those questions/situations that I think most folks have, I sure know that I do. I have always been kind of "dumb" as far as when to not wear my "welcome: out around folks.
I have been very clueless in the past, but with being older, I have had some life experiences in how I deal with said such. I have in the past 1) when I was at a gathering, like at my companies Christmas parties, have asked a fellow employee, that I trusted, to tell me when I was starting to get on peoples nerves 2) I have worked so hard on this myself, as I love humans, but I do have a motor mouth, so I have worked very, very hard through the decades to check and recheck myself at the few gatherings that I have been at to look at folks body language , facial expressions and the like when I am talking either to them or a small group. If I think that I am starting to annoy folks, I usually excuse myself and get a soda, some food, etc. and rejoin after others have taking over the conversation.
Also, I think that if the folks that a person is around are good enough friends then they should be friends. It is always so easy to have "fair weather" friends, but true friends are just that and love the person for whom they are and not a said situation and/or a behavior that they might not usually encounter.
You are a loving and caring soul, one can tell this by your post, as you are concerned about others as well as yourself. You are truly a person with so much empathy and kindness that I am honored if I can call you a great friend.
Take good care of yourself, sending lots of hugs and love to an awesome spirit!
Walter