Last summer, we did one night at SOG and then moved to Coronado Springs, which we booked for close to the same price via a Disney Cardmember deal.
SOG is a beautiful resort on its own, and you'll really enjoy it if you stay there. Our room felt a little tired but otherwise was huge and very comfortable. The major downside for us was transportation. There is no longer a walking path to the Poly, so all park transportation is via bus. But SOG uses its own buses - not Disney's - so for MK they drop you at the TTC rather than the MK bus stops. I can't remember the bus schedule, but I'm thinking they ran a little less frequently than the Disney buses, but they also seemed pretty punctual.
Also, because it's not a Disney property, guests there have to pay for parking - both overnight at SOG and at the parks if you take a car there. The parking charge on top of everything is what swung us in the direction of booking the rest of our stay at a moderate (I didn't have any
DVC points available to use for that trip).
We did the one night at SOG to avoid the cancellation fee (I didn't learn all of this until after my son had booked the room, so he just shortened the reservation) and so that we could enjoy EEH at MK that night. But even coming home from that, we had to take the monorail to the TTC and then wait in a long line for the bus over to SOG - I think we got on the third bus. So despite it being a beautiful and affordable resort, the transportation issues and parking charges were kind of a dealbreaker for me.