If rotating weekly doesn't work for you, maybe try rotating every few days. I find that I like things to keep moving when I play rotationally, so I rotate between households every Sunday and Wednesday. It pushes me to actually do things instead of keeping my sim locked away at home. Also, it helps keep things fresh. As I begin to grow bored of one household, it's time to move to the next.
You can also turn off Neighborhood stories, if you haven't already. It won't stop thr household you're playing from meeting new people when you're not playing them but it will stop them from making other decisions.