Faye, it sounds as if you are trying to make a careful, cost-conscious decision. We are very cost-conscious too. We've stayed in both hotels and timeshare condos, both offsite and w/DVC.
Your answer depends partly on how much you value the onsite experience. We are just as happy at a high-end offsite timeshare resort. Regardless of where we are staying, we prefer to drive, not bus (every DVC resort offers a bus to at least half the parks plus water parks). We use turnstile-package-pick-up rather than next-day-resort-gift-shop-delivery for our purchases. We use our credit cards for purchase protection rather than using our room key. We buy non-expiring park hoppers to stretch our usage over several years (rather than APs). We visit other area parks and attractions during our Orlando vacations. None of us care to get to the parks early for Extra Hours. As you can see, the onsite benefits simply don't matter as much to us as they do to some others.
The DVC resorts are really beautiful. However, we have learned through TUG (see my sig below) to select only the nicest timeshare resorts so we stay in beautiful resorts offsite too. In the past few years, it seems that more offsite area resorts are incorporating the kinds of details in building design, decor, music and lighting, resort activities and customer service that used to be rather unusual outside Disney. Some are such a short drive to some of the parks that it has taken me LESS time to get back and forth for an afternoon break than dealing with onsite transport to an onsite resort.
Your answer depends somewhat on the time of year you like to travel. We visit during all times of the year. We prefer quieter times. But when traveling with others we can end up there on Christmas week or other major holidays. DVC points are very high during these times. Inexpensive offsite timeshare rentals can be tough to find during holiday weeks. But owning and/or trading to offsite timeshares for majoy holidays is downright reasonable by comparison. Something to consider would be an offsite
resale purchase if you want consistently nice, high-end offsite properties (learn to exchange into them at TUG) and you want to try trading for a relatively low cost. If you never expect to visit during school breaks or major holidays, continuing to rent (either DVC or offsite) may make the most sense.
Your answer also depends on how much you value a 2BR vs. a 1BR or studio. Do your children mind sharing a sleeper sofa or using inflatable mattresses? Do you mind having them sleep in your living room? The need for a 2BR w/2 baths for our family is the main reason we sold our DVC. DVC gets quite pricy if you always need a 2BR, especially on weekends.
If you have a wonderful time in offsite timeshares but the cost of renting has gone up and/or you want an easier time managing the quality of your accommodations, it's reasonable to consider renting DVC points for a portion of your next trip. But before you buy, compare the costs with those of a quality resale offsite or within a system that allows you to reserve vacations at their Gold Crown Orlando area resorts - like Sunterra (Cypress Pointe), Fairfield (Bonnet Creek), Hilton (HGVC), etc. 300+ DVC points (2BR week during school breaks) starts at $25,000 resale w/annual fees of $1,200+. Points for a 2BR at one of these offsite companies start around $5,000 w/annual fees of $600+.
I've included our family's reasoning and preferences so you can see if yours may be similar. For someone who is adverse to the offsite option, the lower cost simply wouldn't matter because the option is not acceptable. You mentioned having enjoyed CPGV. So you may want to consider adding a couple of rental nights at DVC to an offsite stay to see for yourselves if the differences are worth the cost to you. Just a thought!

BTW, CPGV is Gold Crown. Bryan's Spanish Cove is not - by a long shot. TUG would help you to be more informed when making selections for renting or timeshare trading.
You are likely to find mostly people here who really care about the onsite "thing" (magic, convenience, benefits, whatever) - because this forum is for DVC members. If you ask on the Orlando forum, you'll find more people like me - who enjoy onsite but enjoy offsite as much or appreciate the monetary value of offsite resorts more than having the onsite thing.
Either way, definitely learn more at TUG (see my sig) before you buy anything for thousand$ of dollars!
