SSR is wonderful. We own there and also just spent three wonderful nights there last week. Our third trip "home" and it was perfect as always.
The resort is finished and beautiful. The new pool area of the Grandstand is fun for kids (spray things) and adults (pool bar). The resort is centrally located. DTD is a zero thing for me too (although we just spent four really fun hours at Disney Quest) but I think the location of this resort is still nothing shabby.
The cm's at SSR were wonderful and I think Artist's Palette is one of the best cs places on WDW property. The resort is spread out, however I have stayed in the Paddock section before and still found the walks to the main area quite doable. My hallway at Boardwalk felt like that hallway in the movie the Shining. It just kept getting longer and longer. Hated that. Hated the lack of cs at BWV too.
I think you never know until you give a try. I cannot imagine that SSR would be so awful you couldn't have a wonderful vacation. It you enjoy tranquil beauty the grounds will not disappoint. If you like the swim the main pool at the Springs and the quiet pools (Grandstand's in particular) will not disappoint. The food at AP is quite good for a quick bite. And if you don't have a car having the resort buses right there at DTD is great for resort dining. If you do have a car, being able to park right outside your unit is wonderful. To me SSR and OKW seem more convenient if you do all four parks. BWV/BC are great for Epcot and MGM but the bus sharing to the other parks stinks.
Clear your head and get excited, I think if you go in with a good attitude you will be pleasantly surprised. If you go in dreading it, it will probably be a self fulfilling prophecy. Good luck and let us know how it goes!