I have (had) a few family members like this - older ones who should have known better, sadly. I can relate to a lot of this, though don’t really have any good suggestions other than lower your expectations of your sister and niece. They’re not going to change now, though it is hard when you can’t have the reciprocal, empathetic relationships you’d like with them.