Went twice on the teachers discount. 1st time we were upgraded, free, to 7th floor amazing view of MGM/BW. 2nd time we were upgraded, free, to the most unbelievable corner room with a huge balcony and two enormous windows. One overlooking MGM/BW, the other overlooking Epcot/BW. We were able to watch Illuminations from bed. From everyone's experience on these boards, it appears that S/D is very generous with their free upgrades. For $129, there's no Disney resort that can even touch S/D for value.
Even without being upgraded, I haven't heard of any bad rooms. I believe the other side of the Dolphin can even see MK when you're high enough.