We just came back from our 4th trip in 2.5 years- a total of 27 days spent at WDW. Prior to that we would stay only 3-4 days in a value or on a really good deal at a Deluxe-- Never stayed Mod. At this point we are almost at our break even point.
Even though Disney is selling SSR and AKv's right now you can actually buy into any other resort through Disney or through resale. The only draw back to the other resorts is that there is about 15 years difference on the contracts-- I sat on the fence for about 1.5 and decided I was going to splurge on our next Disney trip (in Feb06)- We were going to go Deluxe no matter if there was a good deal or not. In Feb 02 we stayed at the Cont for $189 per night-- by Feb 06 it was going to cost us $3000 for 6 days!

Being the frugal girl I am I started looking at DVC again and started crunching the numbers, and crunching the numbers and crunched some more. When I told my guide I really wasn't sure I wanted to buy into SSR she offered me the BWV-- OH MY!!! the BWV!! Where do I sign. Now like I said, I ended up getting 12 years less on my contract and paid more money for it, but to us it was so worth it.
I can't tell you how nice it is to go to Disney every year and stay Deluxe. There is just something magical about the DVC resorts. There is something for everyone. Whether AKV is your favorite or SSR, or VB or HH or even California or Hawaii or even Cruising. My family just LOVES the BWV and VB and we will be buying more points at the KTV very soon (I hope). The buy in cost me about $16,000 for 180 points and this year my dues were $889. Since I paid up front the only real cost is the dues. I stayed 7 nights in a studio and used up 128 points which only cost me $91 per night(or $136 a night if you add in the cost of the time share)in a deluxe boardwalk view room. And since I'm at the break even point that's all it will be costing me for the next 35 years to stay at the BWV.
But once we bought and stayed at the BWV for the first time the money actually became a non-issue. Okay, I really like to get a deal, but knowing that I get to come back to deluxe accomadations, year after year is priceless.
If you are nervous about liking it or the up front cost, buy a smaller resale contract for about 100 points- that way your not as committed. We started slow- 1st contract was for 150 pts and then added another 30 and now want to add another 100 at the Contemporary. What's nice about buying smaller contracts is that you can resell them easier than a larger contract. Another nice thing about a smaller contract is that you aren't committed to Disney every year or for every vacation. You could bank points and stay longer every 2 years.
Good luck with your decision. You will know when its right for you.