I have seen some of the bugs mentioned -- sims popping home from work or school if you load the lot on a holiday, lingering leaf piles, some umbrella up and down delays, and a small amount of teleporting (but I haven't had that stop them from washing the dishes, they just go to the wrong place and then suddenly pop up across the house where they were supposed to be).
And occasional umbrellas in the house -- don't think that's going to keep the sink from leaking on you there, Anais.
https://i.imgur.com/Y137NvU.png
For me it has still been worth it. Weather is always something I've loved in the sims, and the holiday calendar is fun -- especially the ability to edit or create your own holidays.