I don't particularly want actual Sam/Rodney on the show -- I mostly just want them to continue to be sparky and amusing together. Though canon S/R wouldn't bother me the way canon S/J would (no one's reflexively calling anyone else 'sir').

I'm definitely interested in how Sam will interact with John and the rest of the Atlantis crew as the person in charge. She, Daniel, and Teal'c were all such friends and equals that we didn't really get to see her take charge as much.