Welcome to the boards first of all. And don't worry about SSR, lots of resorts are built on ancient Indian burial grounds and few, if any of them, ever mysteriously kill more than 2% of their clientele.
I kid! I kid because I'm a kidder!
Honestly, there's nothing wrong with SSR. It's my "home resort" as well, and I think it's just dandy. The fact that it's often one of the last resorts to fill up, even at peak times, has more to do with other factors than it not being nice (since it is quite nice). Here's how I personally see it...
1: Location. Much like OKW, the original DVC resort is within walking distance of Downtown Disney, with ferries to and from DTD as well. But since SSR is SO huge, "walking distance" is kind of a vague term. Heck, when I stayed there, it was a good 5-minute brisk walk just to get to the main pool and food court (hard to get "your money's worth" with your refillable mugs THAT way). And lots of people prefer to be close to the theme parks. Wilderness Lodge is a ferry ride away from the Magic Kingdom, plus walking distance to Fort Wilderness and the amenities available there. Boardwalk & Beach Club Villas are walking/water taxi distance from both Epcot AND the Studios, plus each other, the Boardwalk Entertainment District is right there, and the Swan & Dolphin is a 2-5 minute walk away. And while ANimal Kingdom Villas aren't walking distance from AK, they do have a unique amenity in the savannahs. I think those are just more attractive resorts for most people for those reasons (and I believe their maintenance dues are more than at OKW and SSR, and that could be the reason).
2: Theming. SSR's AND OKW's theming is amongst the most understated of all the Disney resorts, DVC or otherwise. As a result, some people feel it's less "Disney-ish" than other resorts. Whereas others like the respite of not being inundated with constant reminders that they're at a theme park 24/7.
3: Dining. When I stayed there in the summer of 05, there was the Artist's Palette food court and a few munchies at the Turf Club. Turf Club is now more of a full-serve restaurant, but from reviews I've read, it feels cobbled together, more of an afterthought than a choice. The resturant for people who are staying at SSR, too tired to go anywhere else, but don't want to be served on trays or qait on line. I guess, with so many dining options across the lake, decisions were made to not invest too much in eateries at SSR, but lots of people at least want there to be some options in the resort in which they're staying. However, for people who don't mind the limited dining options, or who make some meals of their own in their kitchen or kitchenette, they're rewarded with a much quieter, pastoral resort experience that seems more relaxed - I believe it was originally promoted with the idea of being a vacation within a vacation.
Believe me, I think there could be more going on at SSR without sacrificing the feeling of solitude. For instance, the "movie theater" could, you know, become an actual working movie theater, much like the movies-under-the-stars at Fort Wilderness. They show movies sometimes at the pool area, but a small theater constantly showing Disney titles would, IMHO, be a great asset for SSR (of course, THAT would mean competition for the UA theater in Downtown Disney, so it probably isn't going to happen). Plus, a resort that size could easily find the space for something that hasn't been developed at WDW in quite a while, a new dinner show ala Poly Luau or Hoop-de-Doo. Something with an old-school vaudeville-in-the-boonies flair would, I think, fit in well with the upstate New York horse-racing community theme. But again, a dinner show there means competition for Cirque du Soleil, plus Pleasure Island's Improv Club and Adventurer's Club. I don't know if WDW's management is afraid adding anything of interest to SSR would cannibalize businesses elsewhere, and they're happy leaving well enough alone, with the Spa making it more alluring as a grownups' WDW resort. But I think more entertainment-based amenities would be the sort of thing that would make people seek SSR out, both to stay onsite, and to visit if they're staying elsewhere.
All of this is my opinion, granted, but when all is said is done, SSR is a beautiful resort, part of that whole Disney magic thing without being hip-deep in it. With the exclusion of Pleasure Island's mini-fireworks at midnight, it's a very peaceful, remote resort that's still close to a whole entertainment district AND with everything else Disney close at hand. Don't worry.