We've stayed at SOG twice, once for a week in 2000 and once for 10 days in 2001. It was before the refurbishment/expansion, so I know some things have changed.
We found it to be a wonderful, wonderful stay. It is a lovely resort, with a very calm, peaceful atmosphere. We actually liked escaping the "Disney" theming when we returned to the hotel from the parks; it felt like an oasis amidst the hubbub.
The transportation is different from the Disney resorts, but still very functional. As an alternative, you can use the Disney transportation options from the Poly. It's a quick, enjoyable walk from SOG to the Poly.
My dh is no longer military, but if we had a chance, we'd definitely stay there again! I think you will be very happy there; it's a great benefit for military families, who deserve all the perks they can get.