Folks are so hard on Sosua, it's actually quite interesting. It's kind of like the way some people scrunch their faces when they hear about Las Vegas, but the city just keeps plugging along.
Sosua will continue to be fine. It survived the invasions of the cheap Germans, budget conscious eurotrash, over-the-hill fratboys, NA mongers, and now NY-homies, it should be good in the years to come. Sosua really is more than just 100 meters on Pedro Clisante.
Same with Cabarete. They are both two nice towns with two very different feels to them. Cabarete has a nice beach and some cool restaurants, but the playa isn't very swimmable, and the whole "one road town" thing gets a bit wearisome after a while. That's why I tend to look at everything from Costambar to Cabrera as more or less one big town. Collectively, it's a lot of fun.
Most cruise stopover points are generally 9-to-5 or 9-to-7 type deals, and the line will do what it can to limit their movements towards "sponsored" excursions. That means golfing, ferry rides, the waterpark, ziplining, tours of puerto plata and maybe going to Rio San Juan. Relatively little non-beach specific traffic will likely be directed to Sosua, although I imagine quite a few guys on "golfing" trips will find their way to Pedro Clisante.
That could, of course, change dramatically if Sosua develops more touristy stuff to pull the cruisers in. They're making good progress, let's give them the credit they deserve. Turning a touristy area around takes time, let's show patience and support.
That said, one trip to DR usually leads to many more. In terms of cost, proximity, and just being all-out fun, it's a great deal.