I DM'd a group through Cormyr: Tearing of the Weave and found it to be lacking in many ways. Though admittedly I was DM'ing a larger group than any published module was intended for, and had a mix of new/experienced players who did not work very well together.

There were a lot of neat mechanics for encounters, but the story felt a little weak, and many of the encounters were just downright mean. Then there's a whole section of the game where the players are in perpetual shadowy illumination and it made for very tedious battles.

YMMV obviously, but I ended up skipping a lot of the final chapter to end it, and the whole group was happier for it being over.