right, but would you see the story differently if it were McKay and Zelenka or Ronon and John????

That's exactly my point. There's nothing in the story that privileges a John&Rodney connection... There's nothing special or unique to their friendship (which to me is the central underlying WNG and, moreover, slash trope :)