As a rule, using DVC to stay at moderates is loosing money. First of all, to stay at moderates now, you would need to buy direct. Resale contracts are not elegible for the Disney Collection or whatever they are calling using points to stay in now-DVC units in WDW.
When you look at the cost per point, plus dues, and how many points are needed to stay at a moderate, it is not worth it. The same thing applies to Disney Cruises too. Using points fo cruises is a horrible waste of money. If you buy DVC with the intent of staying at DVC properties, and then happen to use points once it a while for a cruise or moderate, thats not too bad (its still a money looser, and you would be better off renting out our points and using the cash to book a cruise or moderate). But to buy into DVC with the express intent of using your points for moderate stays or crusing is a very poor choice.
One thing to consider is just how nice the DVC units are - and the included kitchen(ette). Pack in my paying cash days (which ended 10 years ago) I used to stay in moderates too. Since I have owned DVC, I don't think I would want to go back to moderates (or evena regular deluxe room). Having the kitchen makes our vacations a lot better. Not just from a food cost savings, but it makes schedules a lot better. I am the early riser, I get up and make coffee and start an easy breakfast. As the rest of the family rises, some are eating while others are showering or getting ready. We are out the door to the parks a lot faster and with less stress then having to stop and eat somewhere. Sometimes we skip lunch and do an early dinner reservation. It's nice when you get back to room to have some fruit, or a snack. We order from garden grocer when we go, and get maybe $50 - $60 of food. Eggs, bread, pancake mix, chunks of cheese, crackers, some fruit, and a 1/2 gallon of ice cream. No heavy duty cooking, but having that in the room is something that really makes the vacation that much better.
-dave