The buildings across Sherbeth from Silver Lake are some Disney backstage sites---if memory serves, there's a child care center, the Cast recreation center, and I think a Casting building as well. Very few locations from within Silver Lake should see any of this---maybe one side of one or two buildings. From the rest of the resort, you're "inside the gates" and wouldn't have any idea.
I haven't stayed at any of the three, but all are on my list of places I'd be willing to stay. Silver Lake has the advantage of a super location, with very easy access to all things Disney directly from Sherbeth. The two Cypress Pointes have something of a cult following---some people really really like them, and the overall vibe is reportedly very welcoming. Wyndham Cypress Palms is possibly the farthest of the three from the parks, but also has several chain restaurants, a pharmacy, and a Krispy Kreme all within very easy walking distance.
It would be hard to go wrong with any of them, but I think I'd probably take Silver Lake for a Disney-park-centric vacation over the other two.