Also, when I think of the characteristics that people attribute to John, I think they're things that JF put in rather than things that were explicitly written. Such as all of John's dorky expressions (see this vid for an idea), how he slinks all over the place and acts all mellow, or how John freezes up when he's hugged or when women flirt with him, the fact that people find John gay (although, I don't think JF meant to put that in).
That said, even though JF has put a lot of the character into John, I still can't really congratulate the man on it, because I can't help but feel if it were a better actor playing the part, we would probably have of a character. A good actor can take the crumbs that a writer hands him, and turn it into something more. I think the writers draw inspiration for storylines from the actors. In SG-1, Jack was *full* of personality, it was actually Sam, to me at least, that was the flattest character in the group because that's just how AT acted her out. Rodney though, gets a lot of these juicy storylines, because they *know* that David Hewlett can pull the part off. Like, can you honestly see John being in a situation like Duet? When we kind of got a situation like that in Doppelganger, I totally feel he failed at pulling the second character off, and he didn't have to even interrupt himself! Or Grace Under Pressure? In Sanctuary, which is the closest situation, we see him losing his shit, and giving brooding stares a lot (OMG JF, please stop with the brooding stares! You can't pull them off! You look like a dork! Stop trying to be a serious character and go back to being a goofball one please! Because you're one either way, but at least one way is intentional) not really any emotional punch to us, the viewers, not like what we got from Rodney. In fact the only real episodes that are "John-centric" that I felt had emotional punch are Common Ground and The Last Man, and the emotion from those episodes were coming from people other than John. Hell, in The Toa of Rodney, they basically skipped John's chance to be emotional one-on-one, and I have to wonder if JFs acting came into play there.

Part of what makes canon!John work for me is that he can be viewed in nearly any light because at some point, all those lights have been shown to be valid in canon.
And here, I have to wonder if maybe John fans are more likely to sweep his imperfections under the rug. Rodney fans tend to love him for his imperfections, but I wonder what a hardcore John fan would say to your statement. TPTB certainly try to paint John in a good light, and I have to wonder if maybe the fans do the same, only choosing to play with them when it suites them, and covering up, or outright ignoring them the rest of the time.

I think that if John had known what he was getting into, he'd likely have done the same thing. John takes ridiculous risks, often not only to his detriment but that of others, and I think killing the queen is exactly the kind of thing he'd do, so the theory that John doesn't deserve to be blamed for waking the Wraith doesn't hold a lot of water with me.
*nods*
And while you can make the argument that he didn't *know* I call bullshit on that, because Weir wanted him to wait for a minute and mentioned that these might be the badguys that chased away the Ancients. And John, didn't care. Also, on the other side of the balcony door, there was a gateroom full of Athosians who *do* know the Wraith, who have had to live under their threat their entire lives, and have generations worth of knowledge and stories about them. They could have taken a moment to get information from them. They could have brought some of the Athosians with them for help and guidance. They could have done some kind of research on the Wraith before barging in!

You know how much I love listening to you talk about John. :)
You know, for all we both love Rodney more, we do spend most of our time talking about John. :P