This doesn't exactly count, but this scene from SGA supported a thousand and one fics where John and Rodney had at one time been together, but now Rodney's with Keller, but they're both still hurting; or John's finally realizing that there sadly is a Heterosexual Reason for why Rodney's not going to love him back. Or something like that.