We looked at CCV but for us the issue was occupancy. They are converted hotel rooms so its a hard limit of 4 in studio and 1br, so definitely not an option for a family of 5 like us. BRV is a non starter with the 2042 end date for us, but it is at least a lot more flexible since both studio and 1br allow 5.
We bought SSR, cheaper buyin and on the lower end of dues (starting to change some, used to be lowest but creeping up but still in the upper tier for lower dues). We have stayed there once so far. It has a further end date then the 2042 (2054 for SSR) but not nearly as long as some others currently. We are happy to stay at SSR after being there once so far, but have stayed at other resorts booked right at 7 months for all trips but the one so far. To me an advantage to SSR is not having to book at 11 months. We plan to always stay somewhere else if we can at 7 months, but if we dont get it, fall back is SSR 1br (which will never be booked fully at 7 months, same for studios) and waitlist/stalk to move somewhere else if we can. If not, SSR is perfectly fine (has good pools, close to DS, and we had zero issues with using the buses to get to parks).
One of the best things about
DVC is options, there's a ton of ways to do DVC and the ability to tailor to your specific needs is a great thing about it.