I worry a bit about this, too. The only way I might benefit from sentiments might be to play a house for a few more days than I normally do. But then, why would i do that - what is the gain? I understand socials might be a bit more interesting with more depth, but if it's all gone the next time I play the house, there's probably hardly any point in making those sentiments. And they probably won't take say 7 actively played days (not fading while playing other houses), because a sentiment might include a sim living elsewhere, and then if I lay that house, it would be weird if their common sentiment would not fade.
I guess I'll just go with the flow, focusing on short time sentiments, if a good amount lasts for only 12-24 hrs, they might still affect rotational games. I'm actually more worried that the game might waste resources on calculating NAPs' sentiments - it might slow down my game to no gain... Hopefully it's mainly the active household.