You will love it. Your husband, not so much, your kids will be kinda in the middle...
Just kidding, and welcome to the boards. Really wasn't trying to be a turd, but it's hard to tell if anybody is ever going to like anything. All any of us can do is relay our personal stories, which will probably run the same range of stories you've been reading already, some liking, some not liking.
Personally, I've never stayed there, though I've visited and it's nice enough (just when it comes to moderates, I prefer PO-R). But for my sister and her husband, if they can afford to stay at a mod, it's Carribbean or nothing. Her husband even has a room and building he considers the best place in the resort and always asks for it (sorry, can't tell you which room or building, and it's because I don't know, not because I'm afraid you'll be there the same time they are, haha). If you haven't visited allearsnet.com, you should give them a look-see, they have plenty of pictures of all the resorts, and fact sheets as to what's available to do there, like recereational activities, restaurants, shopping, etc.
Carribbean, like Riverside, is pretty spread out, so depending on where you're staying, you may either a: have to do a long hike to get to and from the bus stops or food court or main pool, OR b: have to deal with more noise due to being so close to the action. But bottom line, it's WDW, it shouldn't be too hard to enjoy yourself.