I guess that lack of strategic thinking is why Sheppard beats him at chess.

I love this! And I think you may be correct. And I agree that limitations outside of Rodney's own area of specialization would have made for an excellent character if the writers had just kept that in mind. One more promising idea thrown away...