We just got back from our stay. We did get the "upgrade" to a Lagoon view room, which was nice. We are used to the Contemporary so the Yacht Club feels huge!! Our room was on the back side of the resort (2049) which I actually came to like as we could go out the "back door" to the docks instead of having to walk all the way through the hallways if we wanted to go to Epcot/DHS/the pool.
I really liked the convenience of being able to walk to Epcot/boat to DHS but lordy, the soundproofing is horrible at the Yacht Club. We don't usually go for rope drop but we never managed to sleep past 7:30 am due to loud neighbors or the housekeepers yelling at each other in the hallways bright and early. Having the connecting door probably didn't help, because our neighbor was up at 6:30 am on speaker phone and we could hear every word!
We didn't have any issues with unexpected room checks. I think housekeeping was kind of lacking, we found a bag of skittles behind the daybed from a previous guest, and toys (not ours) and dust bunnies under the bed. Every time we came back to our room midday there would be a huge bag of dirty towels right next to our door, but no housekeepers in our room or in sight.