I was going to mention something about the not looking bit, but you beat me to it.

Much as I would love to think Rodney's actually a good shot but is taking the moral high ground, I don't think that's where they are going on the show.

Almost every time we see him shoot (especially with the P90), he's either a) not looking at all or b) shooting wildly (he tends to shoot one handed and flail around while doing so).

Based on that interpretation, I'd rather not be anywhere near him when he panics and starts firing. I really think Shep was just lucky in "The Long Goodbye," because I really find it hard to believe Rodney would be able to specifically hit the upper arm.

Ditto in "Runner," where I think Rodney was trying to hurt Ford, and then had to deal with the fact that he mostly "winged" him.

But obviously I may be in a minority here. :D