I'm not on my own computer so can't give you direct links or fic names but I know that Lamardeuse has written a few John/Rodney stories that fit your requirements. Her SGA stories are here if you want to have a look - http://lamardeuse.dreamhost.com/sg/index.html